La formula delle brevi escursioni offre la possibilità di visitare bellissimi ambienti naturali e di approfondire la conoscenza di alcune regioni, delle popolazioni che le abitano, dei loro usi e costumi. Si tratta di escursioni giornaliere con partenza da Marrakech e di minitour della durata di 3-4 giorni. Per questi i servizi compresi sono: il pernottamento con prima colazione, il veicolo privato (fuoristrada o minibus) con autista e carburante. La guida parlante italiano è disponibile su richiesta.

 

(default) 12 queries took 85 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`slug`, `Profile`.`description`, `Profile`.`enligne`, (`I18n___description`.`content`) AS `Profile__i18n__description`, (`I18n___enligne`.`content`) AS `Profile__i18n__enligne` FROM `cobratours`.`profiles` AS `Profile` INNER JOIN `cobratours`.`i18n` AS `I18n___description` ON (`Profile`.`id` = `I18n___description`.`foreign_key` AND `I18n___description`.`model` = 'Profile' AND `I18n___description`.`field` = 'description' AND `I18n___description`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___enligne` ON (`Profile`.`id` = `I18n___enligne`.`foreign_key` AND `I18n___enligne`.`model` = 'Profile' AND `I18n___enligne`.`field` = 'enligne' AND `I18n___enligne`.`locale` = 'ita') WHERE `slug` = 'escursioni' LIMIT 1115
2SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "Profile" AND `Media`.`ref_id` = (7) ORDER BY `Media`.`position` ASC 221
3SELECT `_description`.`id`, `_description`.`locale`, `_description`.`model`, `_description`.`foreign_key`, `_description`.`field`, `_description`.`content` FROM `cobratours`.`i18n` AS `_description` WHERE `model` = 'Profile' AND `field` = 'description' AND `_description`.`foreign_key` = (7) 441
4SELECT `_enligne`.`id`, `_enligne`.`locale`, `_enligne`.`model`, `_enligne`.`foreign_key`, `_enligne`.`field`, `_enligne`.`content` FROM `cobratours`.`i18n` AS `_enligne` WHERE `model` = 'Profile' AND `field` = 'enligne' AND `_enligne`.`foreign_key` = (7) 440
5SELECT `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`.`profile_id` = 7 AND `I18n___enligne`.`content` = 19956
6SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "Tour" AND `Media`.`ref_id` IN (35, 36, 37, 39, 42, 43, 44, 61, 115) ORDER BY `Media`.`position` ASC 001
7SELECT `_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` IN (35, 36, 37, 39, 42, 43, 44, 61, 115) 36362
8SELECT `_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` IN (35, 36, 37, 39, 42, 43, 44, 61, 115) 36368
9SELECT `_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` IN (35, 36, 37, 39, 42, 43, 44, 61, 115) 36366
10SELECT `_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` IN (35, 36, 37, 39, 42, 43, 44, 61, 115) 36361
11SELECT `_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` IN (35, 36, 37, 39, 42, 43, 44, 61, 115) 36361
12SELECT `_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` IN (35, 36, 37, 39, 42, 43, 44, 61, 115) 32323