Notice: Undefined index: id in /home/qewjo2z0rdye/public_html/photos/index.php on line 7
Notice: Undefined index: q in /home/qewjo2z0rdye/public_html/photos/index.php on line 8
Notice: Undefined index: l in /home/qewjo2z0rdye/public_html/photos/index.php on line 10
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 '%po'boy%'
GROUP BY p.id
ORDER BY bp.entry_date DESC, p.order_num DESC
LIMIT 0, 200
failed 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 'boy%'
GROUP BY p.id
ORDER BY bp.entry_date DESC, p.order_num DESC
LIMIT 0,' at line 10