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 = 4 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=50 GROUP BY vitrine.vit_id
 
Galerie Photos


 
Entrée - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Démonstration - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Prestations des cavaliers - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Folklore marocain - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Accouplement du gestuelle à la dynamique des rythmes - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Préparation à la compétition - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Fin de course - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Espace repas - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Restaurant - Fantasia Borj Bladi - Marrakech - Fantasia Borj Bladi - Marrakech
Restaurant - Fantasia Borj Bladi - Marrakech

Fantasia Borj Bladi - B.P. 524 - Marrakech - MAROC
Tél. 00212 5 24 43 08 90
 
menu - Fantasia Borj Bladi - Marrakech
 
Bienvenue
Galerie Photos
Activités
Restauration
Plan d'accès
Contact
Diaporama
Retour à l'accueil
 
 © 2002/2017 : terredumonde - terremaroc (v4.0)
 
Où dormir ?
Marrakech
Marrakech et sa région
MAROC
Information
Cultes et edifices Religieux
Festivals & Evenements
Les environs de Marrakech
Visites & Culture
Golf au Maroc