SELECT S.vit_site_menu_photo as `menu`, S.vit_site_menu_color as `couleur`, VR_D.vit_rub_photo, P.pho_photo as `filename`, P.pho_credit_auteur as `fileautor`, AG_LOC.loc_id as agglo_id, AG_D.loc_id as agglo_id, VTPL.vit_rtpl_id, VTPL.vit_rtpl_file, PC.pho_cat_dir as `cat_name`, PC.pho_cat_site_id as `cat_id`, vitrine.vit_id, vitrine.vit_nom, vitrine.vit_pack_id, vitrine.vit_adresse, vitrine.vit_date_modification, vitrine.vit_cp, vitrine.vit_tel1, vitrine.vit_tel2, vitrine.vit_fax, vitrine.vit_ville, vitrine.vit_pays, vitrine.vit_url,coalesce(IF(LENGTH(VI_D.ltext_value),VI_D.ltext_value,NULL),LOC.loc_nom) as `ville`,(PA_D.ltext_value ) as `pays`,(PT_D.pho_txt_nom ) as `filetitle`,(VR_D.vit_rub_titre ) as `titre`,(VR_D.vit_rub_texte ) as `texte`,(VR_D.vit_rub_keywords ) as `keywords`,(VR_D.vit_rub_description ) as `description`,coalesce(IF(LENGTH(AG_D.ltext_value),AG_D.ltext_value,NULL),AG_LOC.loc_nom) as `agglo`,coalesce( vitrine.vit_email1, vitrine.vit_email2 ) as `vit_email`,coalesce( vitrine.vit_tel1, vitrine.vit_tel2 ) as `vit_tel` FROM vitrine LEFT OUTER JOIN vit_site S ON S.vit_id = vitrine.vit_id LEFT OUTER JOIN local_texte VI_D ON VI_D.loc_id = vitrine.vit_ville and VI_D.ltext_langue = 'fr' LEFT OUTER JOIN local_texte PA_D ON PA_D.loc_id = vitrine.vit_pays and PA_D.ltext_langue = 'fr' LEFT OUTER JOIN vit_rubrique VR_D ON VR_D.vit_id = vitrine.vit_id and VR_D.vit_rub_langue = 'fr' AND VR_D.vit_rtype_id = 1 LEFT OUTER JOIN photos P ON P.pho_id = VR_D.vit_rub_photo and VR_D.vit_id = vitrine.vit_id LEFT OUTER JOIN photos_texte PT_D ON PT_D.pho_id = P.pho_id and P.pho_id = VR_D.vit_rub_photo and VR_D.vit_id = vitrine.vit_id and PT_D.pho_txt_langue = 'fr' LEFT OUTER JOIN localisation LOC ON LOC.loc_id = vitrine.vit_ville LEFT OUTER JOIN localisation AG_LOC ON AG_LOC.loc_id = LOC.loc_parent_id LEFT OUTER JOIN local_texte AG_D ON AG_D.loc_id = LOC.loc_parent_id and AG_D.ltext_langue = 'fr' LEFT OUTER JOIN vit_rub_type VRT ON VRT.vit_rtype_id = VR_D.vit_rtype_id and VR_D.vit_id = vitrine.vit_id LEFT OUTER JOIN vit_rub_tpl VTPL ON VTPL.vit_rtpl_id = VRT.vit_rtype_tpl and VRT.vit_rtype_id = VR_D.vit_rtype_id and VR_D.vit_id = vitrine.vit_id LEFT OUTER JOIN photos_categorie PC ON PC.pho_cat_id = P.pho_cat_id and P.pho_id = VR_D.vit_rub_photo and VR_D.vit_id = vitrine.vit_id WHERE vitrine.vit_id=57 GROUP BY vitrine.vit_id

|
|
|
|
|
|
|
|