Query
SELECT SQL_CALC_FOUND_ROWS bp.id blog_post_id, bp.text_id blog_post_text_id, bp.entry_date photo_posted_date, p.id photo_id, p.filename photo_filename, p.label photo_caption, p.place_taken photo_locale, GROUP_CONCAT(t.id SEPARATOR ',') photo_tag_ids, GROUP_CONCAT(t.tag_name SEPARATOR ', ') photo_tags FROM blog_photos p INNER JOIN blog_posts bp ON p.blog_post_id = bp.id LEFT JOIN blog_photos_to_tags bt ON bt.blog_photo_id = p.id LEFT JOIN tags t ON bt.tag_id = t.id AND t.private = 0 WHERE 1=1 AND t.tag_name LIKE '%dorky's%' GROUP BY p.id ORDER BY bp.entry_date DESC, p.order_num DESC LIMIT 0, 200failed with error 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 's%' GROUP BY p.id ORDER BY bp.entry_date DESC, p.order_num DESC LIMIT 0, 2' at line 10