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%' AND cms_tagrel.cms_tagrel_tag_id = cms_tag.cms_tag_id AND cm' at line 24
query:
INSERT INTO tmp_content( cms_tagrel_type, cms_content_title, cms_content_created, cms_content_author, cms_content_thumb, cms_content_fulltext, cms_content_aver_rating, cms_content_catid2, cms_content_id ) SELECT cms_tagrel.cms_tagrel_type as cms_tagrel_type, cms_edpick.cms_edpick_title as cms_content_title, cms_edpick.cms_edpick_created as cms_content_created, cms_edpick.cms_edpick_author as cms_content_author, cms_edpick.cms_edpick_ext_img as cms_content_thumb, cms_edpick.cms_edpick_fulltext as cms_content_fulltext, cms_edpick.cms_edpick_aver_rating as cms_content_aver_rating, cms_edpick.cms_edpick_catid2 as cms_content_catid2, cms_edpick.cms_edpick_id as cms_content_id FROM cms_tagrel,cms_tag,cms_edpick WHERE LOWER(cms_tag.cms_tag_value) like '%khiel's%' AND cms_tagrel.cms_tagrel_tag_id = cms_tag.cms_tag_id AND cms_edpick.cms_edpick_id = cms_tagrel.cms_tagrel_content_id AND cms_tagrel.cms_tagrel_type = "Editor's Pick" AND ( `cms_edpick_publish` = 'Yes' OR (`cms_edpick_publish` = 'Date' AND ('2013-05-23 13:55:50' > `cms_edpick_publish_up` AND ('2013-05-23 13:55:50' < `cms_edpick_publish_down` OR `cms_edpick_publish_down` = '0000-00-00 00:00:00')))) GROUP BY cms_content_id