CTE11 : Ecotour nelle montagne dell'Alto Atlante - 3 giorni


3 giorni - veicolo privato - 2 notti in rifugio confortevole

Immersione nelle atmosfere tradizionali dei villaggi di pietra e di terra, costruiti secondo i dettami di una esperienza secolare, aggrappati ai fianchi ripidi della montagna, circondati da terrazze coltivate, straordinariamente verdi e fiorite in primavera. Il passo lento dei muli dà ritmo alla giornata, il susseguirsi delle stagioni scandisce la vita delle famiglie, difesa da una natura ancora intatta. 

PROGRAMMA

1. Marrakech – Ait Bougmaz via Cascate di Ouzoud, le più alte del Nord Africa, e Azilal. 

2. Ait Bougmaz e regione: camminate nella valle e visite ai villaggi; stesso pernottamento 

3. Ait Bougmaz – Marrakech per lo stesso percorso dell'andata.


(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` = 42 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` = (42) 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` = (42) 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` = (42) 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` = (42) 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` = (42) 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` = (42) 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` = (42) 440
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` = 42 AND `dated` >= '2017-08-16' AND `lang` = 'ita'001