DB 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 'ORDER BY b.start_date DESC, id DESC LIMIT 1) c JOIN retargeting_ads_infos d ON c' at line 1

SELECT c.title, d.* FROM (SELECT b.domain, b.id, b.title FROM retargeting_ads_product a JOIN retargeting_ads b on a.domain=b.domain AND a.retargeting_ads_id=b.id WHERE a.domain='public' AND b.deleted=0 AND a.product_id= ORDER BY b.start_date DESC, id DESC LIMIT 1) c JOIN retargeting_ads_infos d ON c.domain=d.domain AND c.id=d.retargeting_ads_id ORDER BY CASE WHEN d.info_id=1 THEN 1 ELSE 0 END, RAND()

If problem persists, please contact the system administrator.