QUERY: SELECT `property`.*, `property_lang`.*
FROM (`property` FORCE INDEX(is_featured))
JOIN `property_lang` ON `property`.`id` = `property_lang`.`property_id`
LEFT JOIN `property_value` as `pv1` ON `property`.`id` = `pv1`.`property_id`
WHERE `is_activated` =  1
AND `property_lang`.`language_id` =  '10'
AND (pv1.value LIKE '%Grèce - Sud de l'Egée - Dodécanèse -%')
GROUP BY `property`.`id`
ORDER BY `property`.`is_featured` DESC, `property`.`id` DESC
LIMIT 10<br />ERROR: 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 'Egée - Dodécanèse -%')
GROUP BY `property`.`id`
ORDER BY `property`.`is_fe...' at line 7