A Database Error Occurred

Error Number: 1064

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 ') ORDER BY cdp.date' at line 10

SELECT cdp.*, SUBSTRING_INDEX(cdps.name, '-', 1) AS part_name, SUBSTRING_INDEX(cdps.name, '-', 2) AS part_name_guest FROM cache_data_product cdp JOIN cache_data_category cdc ON cdp.category_id = cdc.category_id AND cdc.iso = 'en' JOIN cache_data_product_search cdps ON cdp.product_id = cdps.product_id ANd cdps.iso = 'en' WHERE cdc.act = 1 AND cdp.act = 1 AND cdp.iso = 'en' AND UNIX_TIMESTAMP(DATE_SUB(cdp.date, INTERVAL 36 HOUR )) >= UNIX_TIMESTAMP() AND if( CHAR_LENGTH(cdp.sites) > 0, JSON_CONTAINS(cdp.sites, '"1"', '$.esatoursportevents'), 0) = 1 HAVING ( part_name LIKE '%Milan%' OR part_name_guest LIKE '%Milan%') ) ORDER BY cdp.date

Filename: /home/esatours/public_html/models/front/front_product_model.php

Line Number: 192