Bandeau inférieur

Tourisme/Documents Tourisme à télécharger

Documents Tourisme à télécharger

Plus de 80 documents à télécharger sur le Tourisme en Indre-et-Loire :

Vous pouvez également consulter la rubrique "Téléchargements" pour une recherche multicritères.


LES NOTES DE CONJONCTURE

1 - Ecoscopie 37 - bilans mensuels (2 ans d'archives)

Impossible d'ouvrir la base de données
Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT IsoT0.oid AS IsoF0, IsoT0.m0 AS IsoF1 FROM xrm_category_mask AS IsoT0 INNER JOIN xrm_category AS IsoT2 On (IsoT0.oid = IsoT2.[_oid]) WHERE (IsoT2.gid IN ('zzzzzzzz', 'xxxxxxxx'))
Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_theme.abbrev_fr = 'Tourisme') AND (this.titre_court_doc LIKE ('%' + 'Ecoscopie 37' + '%')) AND (this.titre_court_doc NOT LIKE ('%' + 'Bilan' + '%')) ORDER BY this.debut_publication DESC

Aucun document disponible pour le moment.

2 - Bilans annuels et bilans de saison

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_theme.abbrev_fr = 'Tourisme') AND (this.titre_court_doc LIKE ('%' + 'Bilan' + '%')) ORDER BY this.debut_publication DESC

Aucun document disponible pour le moment.

LES STATS, ETUDES, ANALYSES

1 - Données de cadrage

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_theme.abbrev_fr = 'Tourisme') AND ((this_s_type_document.abbrev_fr = 'Stats') OR (this_s_type_document.abbrev_fr = 'Etude/Analyse')) ORDER BY this.debut_publication DESC

Aucun document disponible pour le moment.

2 - Clientèles touristiques en Indre-et-Loire

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.sous_titre AS this_p_sous_titre, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_theme.abbrev_fr = 'Tourisme - Clientèle') AND ((this_s_type_document.abbrev_fr = 'Stats') OR (this_s_type_document.abbrev_fr = 'Etude/Analyse')) ORDER BY this_s_document.filename ASC

Aucun document disponible pour le moment.

3 - Sites de visites et d'accueil (dont aéroport / lignes aériennes)

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_theme.abbrev_fr = 'Tourisme - Sites de visite et d''accueil') AND ((this_s_type_document.abbrev_fr = 'Stats') OR (this_s_type_document.abbrev_fr = 'Etude/Analyse')) ORDER BY this.debut_publication DESC

Aucun document disponible pour le moment.

4 - Hébergements touristiques : offres et fréquentations en Indre-et-Loire

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_theme.abbrev_fr = 'Tourisme - Hébergement') AND (this_s_type_document.abbrev_fr = 'Stats') ORDER BY this.debut_publication DESC

Aucun document disponible pour le moment.

5 - Hébergements touristiques : offres et fréquentations comparées Touraine, région Centre, France

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_theme.abbrev_fr = 'Tourisme - Hébergement') AND (this_s_type_document.abbrev_fr = 'Etude/Analyse') ORDER BY this.debut_publication DESC, this_s_document.filename ASC

Aucun document disponible pour le moment.

LES CARTES

1 - Sites de visites et d'accueil

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_type_document.label_fr = 'Cartes') AND (this_s_theme.label_fr LIKE ('%' + 'sites de visite' + '%')) ORDER BY this.debut_publication DESC, this_s_document.filename ASC

Aucun document disponible pour le moment.

2 - hébergements touristiques

Erreur SQL: [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_s_type_document.[_oid] AS this_s_type_document, this.nb_pages AS this_p_nb_pages, this.titre_long_doc AS this_p_titre_long_doc, this.edition_libelle AS this_p_edition_libelle, this.debut_publication AS this_p_debut_publication, this_s_type_document.abbrev_fr AS this_s_type_document_p_abbrev_fr, this_s_document.filename AS this_s_document_p_filename, this_s_document.extension AS this_s_document_p_extension, this_s_document.label_fr AS this_s_document_p_label_fr, this_s_document.[_oid] AS this_s_document FROM dm_card_documents AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_documents AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN omc_stringItem AS this_s_theme On ((this.theme = this_s_theme.[_oid]) AND (this_s_theme.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_document On ((this.type_document = this_s_type_document.[_oid]) AND (this_s_type_document.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document On ((this.document = this_s_document.[_oid]) AND (this_s_document.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents') AND (this.titre_long_doc <> '') AND (this_s_theme.label_fr LIKE ('%' + 'Tourisme' + '%')) AND (this_s_type_document.label_fr = 'Cartes') AND (this_s_theme.label_fr LIKE ('%' + 'hébergement' + '%')) ORDER BY this.debut_publication DESC, this_s_document.filename ASC

Aucun document disponible pour le moment.