Marrakech mon amour: le 1000 ragioni per venirci


Marrakech è la città dai mille volti, dove si incontrano tradizione e modernità e proprio questo connubio fra passato e presente, fra caftani e smartphone, crea quella speciale atmosfera che rende la città unica. Il fascino della città è nella vita intensa e brulicante di Jemaa el Fna, nei suoni e profumi che provengono dai souk variopinti, da quella speciale intimità che solo i riad sanno creare, dalla cucina speziata e dall'aroma del dolcissimo tè alla menta...

Marrakech è anche una città d’arte. I suoi monumenti storici sono famosi: dalle Tombe Saadiane tutte in marmo di Carrara ai vasti giardini del palazzo della Bahia, dalla Medersa Ben Youssef tutta in cedro e stucchi traforati al gigantesco minareto della Koutoubia.

L’arte moderna trova spazio in numerose gallerie: pittori e scultori marocchini contemporanei  animano atelier e musei, la fotografia dalle origini ai giorni nostri ha un museo a lei dedicato e infine l’arte povera dei tappeti di stracci ha un suo bellissimo spazio, dove sono esposti autentici capolavori di arte astratta.

E per il vostro benessere troverete una vasta scelta di hammam, dove mani sapienti vi rilassano con massaggi, trattamenti all’olio di argan, di fichi d’india, alghe, erbe aromatiche…

La sera potete fare l’esperienza del cibo di strada di Jemaa el Fna oppure optare per un raffinato ristorante di cucina marocchina, italiana, asiatica…

È la città ideale dove trascorrere un fine settimana, festeggiare un anniversario o regalarsi qualche giorno tutto per sè.


(default) 18 queries took 28 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` = 31 LIMIT 1113
2SELECT `TagsBlogPost`.`blog_post_tag`, `TagsBlogPost`.`blog_post_id` FROM `cobratours`.`tags_blog_posts` AS `TagsBlogPost` WHERE `TagsBlogPost`.`blog_post_id` = (31) 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` = (31) ORDER BY `Media`.`position` ASC 111
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` = (31) 221
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` = (31) 221
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` = (31) 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` = (31) 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` = 31 AND `BlogPostCategoriesBlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) 000
9SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`name`, `BlogPostCategory`.`slug` FROM `cobratours`.`blog_post_categories` AS `BlogPostCategory` WHERE 1 = 1110
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 55515
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) 10101
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) 10101
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