francais anglais espagnol italien allemand
accueil | blog | ajouter aux favoris | envoyer cette page | mon panier
 
accueil
 
[ Idées location ]
  - Riad Marrakech
  - Riad Piscine
  - Villa Marrakech
  - Hôtel Marrakech
  - Riad Agadir
  - Riad Essaouira
  - Villa Essaouira
  - Riad Fès
  - Riad Ouzoud
  - Riad Taroudant
  - Riad Ouarzazate
  - Kasbah Maroc
  - Maison d'Hôtes Marrakech
 
[ Contact ]
 

 
[ Blog ]
  - Agadir
  - Asilah
  - Boumalne du Dadès
  - Casablanca
  - Chefchaouen
  - El Jadida
  - Essaouira
  - Fès
  - Kénitra
  - Laâyoune
  - Larache
  - Marrakech
  - Meknès
  - Merzouga
  - Mhamid
  - Oualidia
  - Ouarzazate
  - Oujda
  - Rabat
  - Safi
  - Salé
  - Tanger
  - Taroudant
  - Tétouan
  - Tinerhir
  - Tiznit
  - Zagora
  - Le Maroc
  - Golf au Maroc
  - Partenaires
  Toutes les informations

 
[ NewsLetter ]
 
  bons plans :
abonnez-vous
 
  se désabonner
 

 
[ Destination ]
  Terre Espagne
  Terre Maroc
  Terre Irlande
  Terre Provence
  Terre Mauritanie
  Terre Bretagne
  Terre Senegal

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
La Kasbah du Sud - La Kasbah du Sud - Ouarzazate
 © 2002/2014 : terredumonde - terremaroc (v4.0)
Bienvenue | Galerie Photos | Plan d'accès | Contact