SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'www.likhom.com'
SELECT puFP FROM factures_produits WITH(NOLOCK) where idFP=21
SELECT top 8 idserv, nomserv, adrpictook, motservde FROM services WITH(NOLOCK) ORDER by ordre
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'page'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'personne'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'personnes'
SELECT francais FROM traduction with(nolock) WHERE allemand= 'schloss' OR allemand= 'schloss' COLLATE French_CI_AI
Select TOP 1 textede, titlereg,titlepays,descreg,descpays, idthem, nomthem, urlthem, nbconn, informations FROM themes WITH(NOLOCK) where urlthem = 'chateau' COLLATE French_CI_AI and actiflig=1
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'chateau'
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
UPDATE themes SET [nbconn]= [nbconn]+1 WHERE idthem='2'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Les séjours à thème'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Découvrir les séjours en locations de charme sur le thème'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambres d''hôtes et Gîtes de charme à thème'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Accueil du site'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Accueil'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Les séjours à thèmes'
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjours à thème'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'alsace-lorraine'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'alsace'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'auvergne-limousin'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'auvergne'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'nord-picardie'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'picardie'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'normandie'
SELECT [nomregde], pays,id,[code reg] FROM [régionmonde] WITH(NOLOCK) WHERE replace(replace([nomregde],' ','-'),'''','-') LIKE 'wallonische-region' COLLATE French_CI_AI
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambres d''hotes et gites au château en ||lieu||'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Vos vacances en chambres d''hotes ou gites de charme dans un château en ||lieu||'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambres d''hôtes et gîtes de charme'
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Les chambres d''hôtes et gites en ||nomregion||'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des chambres d''hôtes et gites ||sejour||'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Carte des chambres d''hôtes et gites ||sejour||'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
Select T.idthem, T.nomthem, T.urlthem FROM themes T WITH(NOLOCK) where T.actiflig=1 and T.parent = 0
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Les séjours à thèmes'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='2' or T2.parent='2') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='2' or T2.parent='2') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'chateau'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='3' or T2.parent='3') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='3' or T2.parent='3') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'bien-etre'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='6' or T2.parent='6') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='6' or T2.parent='6') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'hebergements-insolite'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='7' or T2.parent='7') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='7' or T2.parent='7') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'culture-et-decouverte'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='9' or T2.parent='9') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='9' or T2.parent='9') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='11' or T2.parent='11') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='11' or T2.parent='11') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='12' or T2.parent='12') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='12' or T2.parent='12') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='13' or T2.parent='13') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='13' or T2.parent='13') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'oenologie'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='34' or T2.parent='34') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='34' or T2.parent='34') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'vacances-sportives'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='39' or T2.parent='39') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='39' or T2.parent='39') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'sejour-equitation'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='41' or T2.parent='41') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='41' or T2.parent='41') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='43' or T2.parent='43') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='43' or T2.parent='43') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'gites-et-locations-grande-capacite'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='44' or T2.parent='44') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='44' or T2.parent='44') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='49' or T2.parent='49') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='49' or T2.parent='49') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'accueil-motard'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT SUM(nbre) FROM (select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE (T2.idthem='77' or T2.parent='77') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81' UNION ALL select count( DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] inner join départementmonde D ON V.[code dep] = D.[id] WHERE C.type like '%CG%' AND (T2.idthem='77' or T2.parent='77') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND D.idreg = '81') U
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'sejours-themes-locations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'sejour-amoureux'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
SELECT D.nomdepde, (SELECT SUM(nbre) FROM (select count(DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] WHERE (T2.idthem='2' or T2.parent='2') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND V.[code dep] = D.id UNION ALL select count(DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] WHERE C.type like '%CG%' AND (T2.idthem='2' or T2.parent='2') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND V.[code dep] = D.id) U) FROM départementmonde D WHERE D.idreg='81' AND (SELECT SUM(nbre) FROM (select count(DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] WHERE (T2.idthem='2' or T2.parent='2') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND V.[code dep] = D.id UNION ALL select count(DISTINCT CT.[code chambre]) as nbre FROM [chambre/theme] CT with(nolock) inner join themes T2 with(nolock) ON CT.idthem = T2.idthem inner join chambres C with(nolock) ON CT.[code chambre] = C.[code chambre] inner join villesmonde V with(nolock) ON C.idville=V.[code ville] WHERE C.type like '%CG%' AND (T2.idthem='2' or T2.parent='2') and CT.verif = 1 and C.statut IN ('G','A','B','C','D','R','S','X','Z') AND V.[code dep] = D.id) U) > 0 ORDER BY D.nomdepde
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Liste des séjours à thème'
EXECUTE [dbo].[navigation] '81','CG','','2','','', '20000', 'region', '', '0', '0', '0', '0'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'page'
EXECUTE [dbo].[navigation] '81','CG','','2','','', '15', 'region', '', '0', '0', '0', '0'
Execute vignette 'de', 'BE100005', 'themec2'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'EUR'
SELECT TOP 1 de, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Consultez cette offre en'
Select CT.[textefr] FROM [chambre/theme] CT WITH(NOLOCK) WHERE isnull(CT.[textefr],'') <> '' AND CT.[code chambre] = 'BE100005' AND CT.idthem ='2'
Select CT.[texteen] FROM [chambre/theme] CT WITH(NOLOCK) WHERE isnull(CT.[texteen],'') <> '' AND CT.[code chambre] = 'BE100005' AND CT.idthem ='2'
Select CT.[texteit] FROM [chambre/theme] CT WITH(NOLOCK) WHERE isnull(CT.[texteit],'') <> '' AND CT.[code chambre] = 'BE100005' AND CT.idthem ='2'
Select CT.[textees] FROM [chambre/theme] CT WITH(NOLOCK) WHERE isnull(CT.[textees],'') <> '' AND CT.[code chambre] = 'BE100005' AND CT.idthem ='2'
Select CT.[textenl] FROM [chambre/theme] CT WITH(NOLOCK) WHERE isnull(CT.[textenl],'') <> '' AND CT.[code chambre] = 'BE100005' AND CT.idthem ='2'
Select CT.[textede] FROM [chambre/theme] CT WITH(NOLOCK) WHERE isnull(CT.[textede],'') <> '' AND CT.[code chambre] = 'BE100005' AND CT.idthem ='2'
Select T.[nomthem], C.[nom domaine],T.parent FROM [chambres] C with(nolock) INNER JOIN [chambre/theme] CT WITH(NOLOCK) ON C.[code chambre] = CT.[code chambre] INNER JOIN themes T with(nolock) ON CT.idthem = T.idthem WHERE C.[code chambre] = 'BE100005' AND (T.parent='2' OR CT.idthem ='2')
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Séjour au Château'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Informations'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'page'
SELECT TOP 1 allemand, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'page'

Objet Response erreur 'ASP 0156 : 80004005'

Erreur d'en-tête

/canevas-header.asp, ligne 28

Les en-têtes HTTP sont déjà transmises au navigateur client. Toutes les modifications d'en-tête HTTP doivent être effectuées avant d'écrire le contenu de la page.