CTE-17 : Ouarzazate, oasi di Skoura e Gole del Dadès - 3 giorni


3 giorni - veicolo privato - 2 notti in una kasba ristrutturata nell'oasi di Skoura - partenze ogni giovedì

Lasciata Marrakech e superato il passo del Tizi'n Tichka si scende verso le aride regioni presahariane. A Ouarzazate visita della kasba di Taourirt, complessa e monumentale costruzione fortificata appartenuta al pascià Glaoui. Si prosegue fino all'oasi di Skoura dove si pernotta in una bella kasba restaurata. Il giorno seguente visita dell'oasi di Skoura, della kasba di Amerhidil e delle Gole del Dadès. Il terzo giorno ritorno a Marrakech.

 

PROGRAMMA

 

1. Marrakech - Skoura via il passo del Tizi 'n Tichka (2200 m), Telouet e la spettacolare "Strada del Sale" fino a Ait Benhaddou. La pista offre panorami unici sul fondovalle coltivato e sui villaggi di terra aggrappati alle pareti del canyon.  Cena e pernottamento in una kasba splendidamente ristrutturata.

 

2. Skoura - Valle delle Mille Kasba - valle del Dadès - Skoura. Giornata di scoperta dell'architettura tradizionale locale con la visita della kasba di Amerhidil, annidata nell'oasi di Skoura, un vero labirinto di palme. Continuazione per la valle del Dadès  e le sue famose Gole. Pernottamento a Skoura.

 

3. Skoura - Marrakech. Ritorno a Marrakech via Ouarzazate, dove si visita la kasba di Taourirt, imponente costruzione di terra e residenza del pascià di Marrakech. Arrivo a Marrakech nel tardo pomeriggio. 


(default) 9 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Tour`.`id`, `Tour`.`legend`, `Tour`.`ref`, `Tour`.`title`, `Tour`.`description`, `Tour`.`programme`, `Tour`.`photo_description`, `Tour`.`photo_programme`, `Tour`.`file_programme`, `Tour`.`enligne`, `Tour`.`intro`, `Tour`.`profile_id`, `Tour`.`promotion`, `Tour`.`v_ete`, `Tour`.`v_ete_title`, `Tour`.`v_ete_date`, `Tour`.`v_automne`, `Tour`.`v_automne_title`, `Tour`.`v_automne_date`, `Tour`.`v_hiver`, `Tour`.`v_hiver_title`, `Tour`.`v_hiver_date`, `Tour`.`v_printemp`, `Tour`.`v_printemp_title`, `Tour`.`v_printemp_date`, (`I18n___title`.`content`) AS `Tour__i18n__title`, (`I18n___intro`.`content`) AS `Tour__i18n__intro`, (`I18n___enligne`.`content`) AS `Tour__i18n__enligne`, (`I18n___programme`.`content`) AS `Tour__i18n__programme`, (`I18n___description`.`content`) AS `Tour__i18n__description`, (`I18n___file_programme`.`content`) AS `Tour__i18n__file_programme`, `Profile`.`id`, `Profile`.`name`, `Profile`.`slug`, `Profile`.`description`, `Profile`.`enligne` FROM `cobratours`.`tours` AS `Tour` INNER JOIN `cobratours`.`i18n` AS `I18n___title` ON (`Tour`.`id` = `I18n___title`.`foreign_key` AND `I18n___title`.`model` = 'Tour' AND `I18n___title`.`field` = 'title' AND `I18n___title`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___intro` ON (`Tour`.`id` = `I18n___intro`.`foreign_key` AND `I18n___intro`.`model` = 'Tour' AND `I18n___intro`.`field` = 'intro' AND `I18n___intro`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___enligne` ON (`Tour`.`id` = `I18n___enligne`.`foreign_key` AND `I18n___enligne`.`model` = 'Tour' AND `I18n___enligne`.`field` = 'enligne' AND `I18n___enligne`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___programme` ON (`Tour`.`id` = `I18n___programme`.`foreign_key` AND `I18n___programme`.`model` = 'Tour' AND `I18n___programme`.`field` = 'programme' AND `I18n___programme`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___description` ON (`Tour`.`id` = `I18n___description`.`foreign_key` AND `I18n___description`.`model` = 'Tour' AND `I18n___description`.`field` = 'description' AND `I18n___description`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___file_programme` ON (`Tour`.`id` = `I18n___file_programme`.`foreign_key` AND `I18n___file_programme`.`model` = 'Tour' AND `I18n___file_programme`.`field` = 'file_programme' AND `I18n___file_programme`.`locale` = 'ita') LEFT JOIN `cobratours`.`profiles` AS `Profile` ON (`Tour`.`profile_id` = `Profile`.`id`) WHERE `Tour`.`id` = 44 LIMIT 1113
2SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "Tour" AND `Media`.`ref_id` = (44) ORDER BY `Media`.`position` ASC 000
3SELECT `_title`.`id`, `_title`.`locale`, `_title`.`model`, `_title`.`foreign_key`, `_title`.`field`, `_title`.`content` FROM `cobratours`.`i18n` AS `_title` WHERE `model` = 'Tour' AND `field` = 'title' AND `_title`.`foreign_key` = (44) 440
4SELECT `_intro`.`id`, `_intro`.`locale`, `_intro`.`model`, `_intro`.`foreign_key`, `_intro`.`field`, `_intro`.`content` FROM `cobratours`.`i18n` AS `_intro` WHERE `model` = 'Tour' AND `field` = 'intro' AND `_intro`.`foreign_key` = (44) 440
5SELECT `_enligne`.`id`, `_enligne`.`locale`, `_enligne`.`model`, `_enligne`.`foreign_key`, `_enligne`.`field`, `_enligne`.`content` FROM `cobratours`.`i18n` AS `_enligne` WHERE `model` = 'Tour' AND `field` = 'enligne' AND `_enligne`.`foreign_key` = (44) 440
6SELECT `_programme`.`id`, `_programme`.`locale`, `_programme`.`model`, `_programme`.`foreign_key`, `_programme`.`field`, `_programme`.`content` FROM `cobratours`.`i18n` AS `_programme` WHERE `model` = 'Tour' AND `field` = 'programme' AND `_programme`.`foreign_key` = (44) 440
7SELECT `_description`.`id`, `_description`.`locale`, `_description`.`model`, `_description`.`foreign_key`, `_description`.`field`, `_description`.`content` FROM `cobratours`.`i18n` AS `_description` WHERE `model` = 'Tour' AND `field` = 'description' AND `_description`.`foreign_key` = (44) 440
8SELECT `_file_programme`.`id`, `_file_programme`.`locale`, `_file_programme`.`model`, `_file_programme`.`foreign_key`, `_file_programme`.`field`, `_file_programme`.`content` FROM `cobratours`.`i18n` AS `_file_programme` WHERE `model` = 'Tour' AND `field` = 'file_programme' AND `_file_programme`.`foreign_key` = (44) 441
9SELECT `Periode`.`id`, `Periode`.`tours_id`, `Periode`.`dated`, `Periode`.`datef`, `Periode`.`enligne`, `Periode`.`lang`, `Tour`.`id`, `Tour`.`legend`, `Tour`.`ref`, `Tour`.`title`, `Tour`.`description`, `Tour`.`programme`, `Tour`.`photo_description`, `Tour`.`photo_programme`, `Tour`.`file_programme`, `Tour`.`enligne`, `Tour`.`intro`, `Tour`.`profile_id`, `Tour`.`promotion`, `Tour`.`v_ete`, `Tour`.`v_ete_title`, `Tour`.`v_ete_date`, `Tour`.`v_automne`, `Tour`.`v_automne_title`, `Tour`.`v_automne_date`, `Tour`.`v_hiver`, `Tour`.`v_hiver_title`, `Tour`.`v_hiver_date`, `Tour`.`v_printemp`, `Tour`.`v_printemp_title`, `Tour`.`v_printemp_date` FROM `cobratours`.`periodes` AS `Periode` LEFT JOIN `cobratours`.`tours` AS `Tour` ON (`Periode`.`tours_id` = `Tour`.`id`) WHERE `tours_id` = 44 AND `dated` >= '2017-06-27' AND `lang` = 'ita'000