Tourisme

Accueil

SELECT DISTINCT cp.id_product, i18n.traduction_fr as libelle, cpap1.value as date_publication, cpap2.value as lien, cpap3.value as source FROM cat_product cp JOIN cat_product_famille cpf ON cpf.id_product = cp.id_product JOIN cat_product_additionnal_properties cpap1 ON cpap1.id_product = cp.id_product JOIN cat_product_additionnal_properties cpap2 ON cpap2.id_product = cp.id_product JOIN cat_product_additionnal_properties cpap3 ON cpap3.id_product = cp.id_product JOIN i18n ON i18n.shortcut = cp.libelle WHERE cpap1.id_champs = "196" AND cpap1.lang = "fr" AND cpap2.lang = "fr" AND cpap3.lang = "fr" AND cpap2.id_champs = "197" AND cpap3.id_champs = "198" AND cpf.id_famille = "62" AND cp.display = 1 ORDER BY STR_TO_DATE(cpap1.value, "%d/%m/%Y") DESC LIMIT 0, 10