Error!
MySQL 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 'Ivoire') ) and contents.id IN (select content_taxonomy.content_id from content_t' at line 1
SQL Statement: SELECT contents.*, packages.title as packagesTitle,asset_packages.expire_at, GROUP_CONCAT(asset_packages.resource_properties_remaining separator '##|##') AS resource_properties_remaining FROM contents JOIN asset_packages on asset_packages.resource_id = contents.id join packages on asset_packages.package_id = packages.id WHERE contents.id IN(SELECT content_locations.content_id FROM content_locations,locations WHERE content_locations.location_id=locations.id AND (locations.country='CI' OR locations.country='Cote d'Ivoire') ) and contents.id IN (select content_taxonomy.content_id from content_taxonomy where taxonomy_id=12063) and contents.publish_date <= '2024-06-25 03:00:00' and contents.published=1 and contents.magazine_id=11 and asset_packages.published = 1 and asset_packages.resource = contents.resource_id group by contents.id ORDER BY contents.title ASC