3 notti nel Sahara


Nell'estremo sud oltre la valle del Draa il fiume si perde fra le sabbie. Le vaste distese di dune sono il nostro "miraggio": il pernottamento nel deserto si fa in tenda, in un campo attrezzato, rispettoso delle tradizioni e dell'ambiente.

PROGRAMMA

1.  Marrakech – Ouarzazate. Partenza verso l'Alto Atlante e il passo del Tizi 'n Tichka (2200 m). Deviazione per Telouet, piccolo villaggio di montagna che ospita l'enorme kasba in rovina del pascià Glaoui e continuazione lungo la "Pista del Sale", che sebbene asfaltata rimane uno spettacolare tragitto fra villaggi sospesi sui ripidi fianchi della montagna. Sosta a Ait Benhaddou, bel villaggio di terra, inserito nella lista del Patrimonio dell'Umanità. Arrivo a Ouarzazate. Pernottamento in kasba restaurata.

2. Ouarzazate – Erg Lihoudi. Ancora un passo di montagna a 1880 m e poi si scende nella verde Valle del Draa, famosa per le kasba di terra pressata. Visita all'antico villaggio di Tamnougalt, un tempo capitale della valle, e al sito di incisioni rupestri di Tinzouline. Pernottamento in campo tendato all'Erg Lihoudi ai piedi della Grande Duna, che si raggiunge a dorso di dromedario con una passeggiata di circa mezz'ora.

3. Erg Lihoudi – Marrakech. Il tragitto di ritorno è un ripercorrere i paesaggi della Valle del Draa e dell'Alto Atlante, sempre diversi a seconda della luce, dei colori della montagna e delle coltivazioni a terrazza. Arrivo a Marrakech nel tardo pomeriggio. 


(default) 18 queries took 25 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `BlogPost`.`id`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`media_id`, `BlogPost`.`enligne`, `BlogPost`.`sticky`, `BlogPost`.`in_rss`, `BlogPost`.`meta_title`, `BlogPost`.`meta_description`, `BlogPost`.`meta_keywords`, `BlogPost`.`created`, `BlogPost`.`modified`, (`I18n___title`.`content`) AS `BlogPost__i18n__title`, (`I18n___slug`.`content`) AS `BlogPost__i18n__slug`, (`I18n___summary`.`content`) AS `BlogPost__i18n__summary`, (`I18n___body`.`content`) AS `BlogPost__i18n__body`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position` FROM `cobratours`.`blog_posts` AS `BlogPost` INNER JOIN `cobratours`.`i18n` AS `I18n___title` ON (`BlogPost`.`id` = `I18n___title`.`foreign_key` AND `I18n___title`.`model` = 'BlogPost' AND `I18n___title`.`field` = 'title' AND `I18n___title`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___slug` ON (`BlogPost`.`id` = `I18n___slug`.`foreign_key` AND `I18n___slug`.`model` = 'BlogPost' AND `I18n___slug`.`field` = 'slug' AND `I18n___slug`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___summary` ON (`BlogPost`.`id` = `I18n___summary`.`foreign_key` AND `I18n___summary`.`model` = 'BlogPost' AND `I18n___summary`.`field` = 'summary' AND `I18n___summary`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___body` ON (`BlogPost`.`id` = `I18n___body`.`foreign_key` AND `I18n___body`.`model` = 'BlogPost' AND `I18n___body`.`field` = 'body' AND `I18n___body`.`locale` = 'ita') LEFT JOIN `cobratours`.`medias` AS `Thumb` ON (`BlogPost`.`media_id` = `Thumb`.`id`) WHERE `BlogPost`.`id` = 20 LIMIT 1113
2SELECT `TagsBlogPost`.`blog_post_tag`, `TagsBlogPost`.`blog_post_id` FROM `cobratours`.`tags_blog_posts` AS `TagsBlogPost` WHERE `TagsBlogPost`.`blog_post_id` = (20) 000
3SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "BlogPost" AND `Media`.`ref_id` = (20) ORDER BY `Media`.`position` ASC 110
4SELECT `_title`.`id`, `_title`.`locale`, `_title`.`model`, `_title`.`foreign_key`, `_title`.`field`, `_title`.`content` FROM `cobratours`.`i18n` AS `_title` WHERE `model` = 'BlogPost' AND `field` = 'title' AND `_title`.`foreign_key` = (20) 220
5SELECT `_slug`.`id`, `_slug`.`locale`, `_slug`.`model`, `_slug`.`foreign_key`, `_slug`.`field`, `_slug`.`content` FROM `cobratours`.`i18n` AS `_slug` WHERE `model` = 'BlogPost' AND `field` = 'slug' AND `_slug`.`foreign_key` = (20) 220
6SELECT `_summary`.`id`, `_summary`.`locale`, `_summary`.`model`, `_summary`.`foreign_key`, `_summary`.`field`, `_summary`.`content` FROM `cobratours`.`i18n` AS `_summary` WHERE `model` = 'BlogPost' AND `field` = 'summary' AND `_summary`.`foreign_key` = (20) 221
7SELECT `_body`.`id`, `_body`.`locale`, `_body`.`model`, `_body`.`foreign_key`, `_body`.`field`, `_body`.`content` FROM `cobratours`.`i18n` AS `_body` WHERE `model` = 'BlogPost' AND `field` = 'body' AND `_body`.`foreign_key` = (20) 221
8SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`parent_id`, `BlogPostCategory`.`lft`, `BlogPostCategory`.`rght`, `BlogPostCategory`.`name`, `BlogPostCategory`.`slug`, `BlogPostCategory`.`meta_title`, `BlogPostCategory`.`meta_description`, `BlogPostCategory`.`meta_keywords`, `BlogPostCategory`.`rss_channel_title`, `BlogPostCategory`.`rss_channel_description`, `BlogPostCategory`.`blog_post_count`, `BlogPostCategory`.`under_blog_post_count`, `BlogPostCategory`.`created`, `BlogPostCategory`.`modified`, `BlogPostCategoriesBlogPost`.`blog_post_category_id`, `BlogPostCategoriesBlogPost`.`blog_post_id` FROM `cobratours`.`blog_post_categories` AS `BlogPostCategory` JOIN `cobratours`.`blog_post_categories_blog_posts` AS `BlogPostCategoriesBlogPost` ON (`BlogPostCategoriesBlogPost`.`blog_post_id` = 20 AND `BlogPostCategoriesBlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) 001
9SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`name`, `BlogPostCategory`.`slug` FROM `cobratours`.`blog_post_categories` AS `BlogPostCategory` WHERE 1 = 1111
10SELECT `TagsBlogPost`.`blog_post_tag`, `TagsBlogPost`.`blog_post_id` FROM `cobratours`.`tags_blog_posts` AS `TagsBlogPost` WHERE 1 = 1000
11SELECT `BlogPost`.`id`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`media_id`, `BlogPost`.`enligne`, `BlogPost`.`sticky`, `BlogPost`.`in_rss`, `BlogPost`.`meta_title`, `BlogPost`.`meta_description`, `BlogPost`.`meta_keywords`, `BlogPost`.`created`, `BlogPost`.`modified`, (`I18n___title`.`content`) AS `BlogPost__i18n__title`, (`I18n___slug`.`content`) AS `BlogPost__i18n__slug`, (`I18n___summary`.`content`) AS `BlogPost__i18n__summary`, (`I18n___body`.`content`) AS `BlogPost__i18n__body`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position` FROM `cobratours`.`blog_posts` AS `BlogPost` INNER JOIN `cobratours`.`i18n` AS `I18n___title` ON (`BlogPost`.`id` = `I18n___title`.`foreign_key` AND `I18n___title`.`model` = 'BlogPost' AND `I18n___title`.`field` = 'title' AND `I18n___title`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___slug` ON (`BlogPost`.`id` = `I18n___slug`.`foreign_key` AND `I18n___slug`.`model` = 'BlogPost' AND `I18n___slug`.`field` = 'slug' AND `I18n___slug`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___summary` ON (`BlogPost`.`id` = `I18n___summary`.`foreign_key` AND `I18n___summary`.`model` = 'BlogPost' AND `I18n___summary`.`field` = 'summary' AND `I18n___summary`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___body` ON (`BlogPost`.`id` = `I18n___body`.`foreign_key` AND `I18n___body`.`model` = 'BlogPost' AND `I18n___body`.`field` = 'body' AND `I18n___body`.`locale` = 'ita') LEFT JOIN `cobratours`.`medias` AS `Thumb` ON (`BlogPost`.`media_id` = `Thumb`.`id`) WHERE `BlogPost`.`enligne` = 1 ORDER BY `BlogPost`.`id` desc LIMIT 55511
12SELECT `TagsBlogPost`.`blog_post_tag`, `TagsBlogPost`.`blog_post_id` FROM `cobratours`.`tags_blog_posts` AS `TagsBlogPost` WHERE `TagsBlogPost`.`blog_post_id` IN (33, 32, 31, 28, 27) 000
13SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "BlogPost" AND `Media`.`ref_id` IN (33, 32, 31, 28, 27) ORDER BY `Media`.`position` ASC 991
14SELECT `_title`.`id`, `_title`.`locale`, `_title`.`model`, `_title`.`foreign_key`, `_title`.`field`, `_title`.`content` FROM `cobratours`.`i18n` AS `_title` WHERE `model` = 'BlogPost' AND `field` = 'title' AND `_title`.`foreign_key` IN (33, 32, 31, 28, 27) 10102
15SELECT `_slug`.`id`, `_slug`.`locale`, `_slug`.`model`, `_slug`.`foreign_key`, `_slug`.`field`, `_slug`.`content` FROM `cobratours`.`i18n` AS `_slug` WHERE `model` = 'BlogPost' AND `field` = 'slug' AND `_slug`.`foreign_key` IN (33, 32, 31, 28, 27) 10101
16SELECT `_summary`.`id`, `_summary`.`locale`, `_summary`.`model`, `_summary`.`foreign_key`, `_summary`.`field`, `_summary`.`content` FROM `cobratours`.`i18n` AS `_summary` WHERE `model` = 'BlogPost' AND `field` = 'summary' AND `_summary`.`foreign_key` IN (33, 32, 31, 28, 27) 10101
17SELECT `_body`.`id`, `_body`.`locale`, `_body`.`model`, `_body`.`foreign_key`, `_body`.`field`, `_body`.`content` FROM `cobratours`.`i18n` AS `_body` WHERE `model` = 'BlogPost' AND `field` = 'body' AND `_body`.`foreign_key` IN (33, 32, 31, 28, 27) 10102
18SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`parent_id`, `BlogPostCategory`.`lft`, `BlogPostCategory`.`rght`, `BlogPostCategory`.`name`, `BlogPostCategory`.`slug`, `BlogPostCategory`.`meta_title`, `BlogPostCategory`.`meta_description`, `BlogPostCategory`.`meta_keywords`, `BlogPostCategory`.`rss_channel_title`, `BlogPostCategory`.`rss_channel_description`, `BlogPostCategory`.`blog_post_count`, `BlogPostCategory`.`under_blog_post_count`, `BlogPostCategory`.`created`, `BlogPostCategory`.`modified`, `BlogPostCategoriesBlogPost`.`blog_post_category_id`, `BlogPostCategoriesBlogPost`.`blog_post_id` FROM `cobratours`.`blog_post_categories` AS `BlogPostCategory` JOIN `cobratours`.`blog_post_categories_blog_posts` AS `BlogPostCategoriesBlogPost` ON (`BlogPostCategoriesBlogPost`.`blog_post_id` IN (33, 32, 31, 28, 27) AND `BlogPostCategoriesBlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) 000