Translate

2012 Member Review Competition Entries

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':french-roundabouts-whats-correct)) AND (rev.review != '' AND rev.published = 1' at line 1 SQL=SELECT sitem.itemid, sitem.title, sitem.icon, sitem.image , rev.title AS reviewTitle, rev.review AS reviewText, rev.username AS reviewAuthor FROM jos_sobi2_plugin_reviews AS rev LEFT JOIN jos_sobi2_item AS sitem ON sitem.itemid = rev.itemid WHERE (sitem.itemid IN (SELECT itemid FROM jos_sobi2_cat_items_relations WHERE catid = 3:french-roundabouts-whats-correct)) AND (rev.review != '' AND rev.published = 1 AND sitem.published = 1 AND (sitem.publish_down > '2012-05-17 10:12:08' OR sitem.publish_down = '0000-00-00 00:00:00')) ORDER BY rev.added DESC LIMIT 0, 3

My favourite places