SELECT `fv_catalog_item`.`id`, `fv_catalog_item`.`alias`, `fv_catalog_item`.`alias_en`, `fv_catalog_item`.`alias_it`, `fv_catalog_item`.`alias_de`, `fv_catalog_item`.`alias_fr`, `fv_catalog_item`.`alias_he`, `fv_catalog_item`.`image_link`, `fv_catalog_item`.`factory_id`, `fv_catalog_item`.`bestseller`, `fv_catalog_item`.`novelty`, `fv_catalog_item`.`removed`, `fv_catalog_item`.`price_from`, `fv_catalog_item`.`currency`, `fv_catalog_item`.`updated_at`, `fv_catalog_item_lang`.`title` FROM `fv_catalog_item` INNER JOIN `fv_catalog_item_lang` ON (`fv_catalog_item`.`id` = `fv_catalog_item_lang`.`rid`) AND (`fv_catalog_item_lang`.`lang`='fr-FR') INNER JOIN `fv_catalog_factory` ON `fv_catalog_item`.`factory_id` = `fv_catalog_factory`.`id` INNER JOIN `fv_catalog_type` ON `fv_catalog_item`.`catalog_type_id` = `fv_catalog_type`.`id` WHERE ((`fv_catalog_item`.`removed`='0') AND (`fv_catalog_factory`.`published`='1') AND (`fv_catalog_factory`.`deleted`='0') AND (`fv_catalog_factory`.`show_for_fr`='1')) AND (`fv_catalog_item`.published = '1') AND (`fv_catalog_item`.deleted = '0') AND (`fv_catalog_type`.`alias_fr`='accessoires') AND (`fv_catalog_factory`.`alias`='savio-firmino') AND ((`fv_catalog_factory`.published = '1') AND (`fv_catalog_factory`.deleted = '0')) AND ((`fv_catalog_type`.published = '1') AND (`fv_catalog_type`.deleted = '0')) AND ((`fv_catalog_factory`.published = '1') AND (`fv_catalog_factory`.deleted = '0')) ORDER BY `fv_catalog_item`.`updated_at` DESC