Error in query SELECT `property`.*, `property_lang`.* FROM (`property` FORCE INDEX(is_featured)) JOIN `property_lang` ON `property`.`id` = `property_lang`.`property_id` WHERE `is_activated` = 1 AND `is_visible` = 1 AND `language_id` = '1' AND (search_values LIKE '%commercial%') ORDER BY `property`.`is_featured` DESC, `id` DESC LIMIT 100