CTE8 : La Bianca Essaouira escursione di 1 giorno


Andata e ritorno in giornata oppure due giorni con pernottamento in riad

Essaouira é una pittoresca cittadina di mare le cui origini si perdono nella storia. Fu scalo fenicio e centro di produzione della porpora; villaggio di pescatori, fu ricostruita e fortificata nel XVIII secolo con una medina, un porto e un mellah (quartiere ebraico). Cittadina animata e cosmopolita, ospita un festival seguitissimo di musica "Gnawa", numerose gallerie d'arte e un porto animato, dove si costruiscono in maniera artigianale piccoli pescherecci.


(default) 9 queries took 9 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` = 39 LIMIT 1117
2SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "Tour" AND `Media`.`ref_id` = (39) 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` = (39) 441
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` = (39) 441
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` = (39) 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` = (39) 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` = (39) 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` = (39) 330
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` = 39 AND `dated` >= '2017-10-23' AND `lang` = 'ita'000