A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Achigan%' ) ) AND ( (lmk_posts.unique_id NOT IN (SELECT lmk_report.unique_id ...' at line 5

SELECT `lmk_posts`.*, `lmk_locations`.`currency_symbol` as currency_symbol FROM (`lmk_posts`) LEFT JOIN `lmk_locations` ON `lmk_locations`.`id`=`lmk_posts`.`country` WHERE ( lmk_posts.post_usage_status = '1' OR lmk_posts.post_usage_status = '0' ) AND (lmk_posts.city IN (select id from lmk_locations where lmk_locations.name like '%Saint-Roch-de-l'Achigan%' ) ) AND ( (lmk_posts.unique_id NOT IN (SELECT lmk_report.unique_id FROM lmk_report GROUP BY lmk_report.unique_id HAVING COUNT(lmk_report.unique_id)>=1 )) AND lmk_posts.created_by NOT IN (SELECT lmk_report_user.to_user_id FROM lmk_report_user HAVING COUNT(lmk_report_user.to_user_id) >=1)) AND `lmk_posts`.`is_block` = '0' AND ((lmk_posts.id IN (SELECT post_id FROM lmk_subscription WHERE lmk_subscription.expiry_date>=2024-03-29) OR DATE_FORMAT(lmk_posts.publish_time,"%Y-%m-%d")<2024-09-25) OR (lmk_posts.id NOT IN (SELECT post_id FROM lmk_subscription) )) AND ((lmk_posts.id IN (SELECT post_id FROM lmk_subscription WHERE lmk_subscription.expiry_date>=2024-03-29) OR DATE_FORMAT(lmk_posts.publish_time,"%Y-%m-%d")<2024-09-25) OR (lmk_posts.id NOT IN (SELECT post_id FROM lmk_subscription) )) AND lmk_posts.title NOT LIKE '%sex%' AND lmk_posts.description NOT LIKE '%sex%' AND lmk_posts.title NOT LIKE '%cam sex%' AND lmk_posts.description NOT LIKE '%cam sex%' AND lmk_posts.title NOT LIKE '%hot girls%' AND lmk_posts.description NOT LIKE '%hot girls%' AND lmk_posts.title NOT LIKE '%marijuana%' AND lmk_posts.description NOT LIKE '%marijuana%' AND lmk_posts.title NOT LIKE '%fuck%' AND lmk_posts.description NOT LIKE '%fuck%' AND ( lmk_posts.category = '110' OR lmk_posts.parent_category = '110' ) AND `lmk_posts`.`search_meta` LIKE '%Jobs%' AND `lmk_posts`.`featured` = 0 AND (lmk_posts.`status` = '1' OR lmk_posts.`status` = '5') ORDER BY `lmk_posts`.`updated_time` desc LIMIT 10

Filename: /home/letmekno/public_html/modules/show/models/show_model_core.php

Line Number: 1394