SELECT TOP 1 anglais, 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, motserven FROM services WITH(NOLOCK) ORDER by ordre
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'page'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'personne'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'personnes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'personne'
SELECT V.[nomvilleen],D.[nomdepen], R.[nomregen], P.[nompaysen], L.adresse, L.tel , L.Numlieu, L.codecatlieu, V.[code dep], L.codpost, L.lat, L.lng, L.site, L.email, L.ville,L.nomlieu,L.idville ,P.code, L.pays from lieux L WITH (NOLOCK) INNER JOIN villesmonde V with(nolock) ON L.idville = V.[code ville] INNER JOIN départementmonde D WITH (NOLOCK) ON V.[code dep] = D.id INNER JOIN régionmonde R WITH (NOLOCK) ON D.idreg = R.id INNER JOIN pays P WITH (NOLOCK) ON R.pays = P.code WHERE ( V.[nomvilleen]='zaventem' or V.[nomvilleen]='zaventem' ) AND LOWER(replace(replace(replace(L.[nomlieu],' ','-'),'''','-'),'°','-')) LIKE 'brussels-national-airport' COLLATE French_CI_AI
SELECT [nom affiché], [nomdepen] FROM départementmonde WHERE [id] = '432'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambres-proche-loisir'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'France'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Activités disponibles à proximité'
SELECT libellecatlieu FROM categorielieux WITH (NOLOCK) where codecatlieu = '1'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Aéroports / Aérodromes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'page'
EXECUTE [dbo].[Rech_serv_capacite_rand_loisir] '77574','', '15', 'ville', '', '0', '', '', '0'
EXECUTE [dbo].[Rech_serv_capacite_round_loisir] '30','50.905','4.4893','-','en', '77574', '' , '15' ,'ville' , '', '0'
Execute vignette 'en', 'BE180001', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Texte de présentation en'
Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='fr' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001'
Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='en' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001'
Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='it' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001'
Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='es' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001'
Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='nl' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001'
Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='de' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE100014', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE120046', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE120053', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE100004', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE110014', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE100001', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE120010', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE120037', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE110004', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE120055', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Lire la suite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE150003', 'classiqueG'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'personnes'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'gite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Gîte'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Gîte'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'sem'
Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Texte de présentation en'
Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='fr' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003'
Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='en' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003'
Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='it' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003'
Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='es' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003'
Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='nl' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003'
Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='de' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE150002', 'classiqueG'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'personnes'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'gite'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Gîte'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Gîte'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'sem'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE120006', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
Execute vignette 'en', 'BE130019', 'classiqueC'
Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP'
SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'jour'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Détails'
SELECT TOP 1 numlieu from LieuxStats where numlieu like '5628' and [moiscourant] like '19/04'
UPDATE LieuxStats SET [ANGnbconn]= [ANGnbconn]+1 WHERE numlieu like '5628' and [moiscourant] like '19/04'
SELECT libelle FROM descriptions with(nolock) WHERE ISNULL(libelle,'') <> '' AND idlang='en' AND libtype='lieux' AND idtype = '5628' AND statut = 1
Select url,titre FROM photos with(nolock) WHERE idtype = '5628' AND statut = 1 AND libtype='lieux' order by principale desc
Select (L.nomlieu) as nom, (V.[nomvilleen]) as nom1, (D.[nomdepen]) as nom2, (R.[nomregen]) as nom3, (P.[nompaysen]) as nom4 from lieux L with(nolock) INNER JOIN villesmonde V with(nolock) ON L.[idville] = V.[code ville] INNER JOIN départementmonde D with(nolock) ON V.[code dep] = D.id INNER JOIN régionmonde R with(nolock) ON D.idreg = R.id INNER JOIN pays P with(nolock) ON R.pays = P.code where L.[Numlieu] = '5628'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambres d''hôtes et gîtes proche : ||lieu||'
SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traductionsupp WITH (NOLOCK) WHERE francais= 'Chambres d''hôtes et gîtes proche : ||lieu||'
INSERT INTO traduction (francais,emplace,type,url,dateacces) VALUES ('Chambres d''hôtes et gîtes proche : ||lieu||','C','T','/loisir-proche-chambre.asp','23/04/2019')

Microsoft OLE DB Provider for ODBC Drivers erreur '80040e07'

[Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

/fonctions_asp/fonction-likhom-bd.asp, ligne 18