SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'www.likhom.com'<br />SELECT puFP FROM factures_produits WITH(NOLOCK) where idFP=21<br />SELECT top 8 idserv, nomserv, adrpictook, motserven FROM services WITH(NOLOCK) ORDER by ordre<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'page'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personne'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personnes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personne'<br />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<br />SELECT [nom affiché], [nomdepen] FROM départementmonde WHERE [id] = '432' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambres-proche-loisir' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'France'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Activités disponibles à proximité'<br />SELECT libellecatlieu FROM categorielieux WITH (NOLOCK) where codecatlieu = '1' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Aéroports / Aérodromes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'page'<br />EXECUTE [dbo].[Rech_serv_capacite_rand_loisir] '77574','', '15', 'ville', '', '0', '', '', '0'<br />EXECUTE [dbo].[Rech_serv_capacite_round_loisir] '30','50.905','4.4893','-','en', '77574', '' , '15' ,'ville' , '', '0' <br />Execute vignette 'en', 'BE180001', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Texte de présentation en'<br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='fr' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='en' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='it' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='es' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='nl' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='de' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'BE180001' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE100014', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE120046', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE120053', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE100004', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE110014', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE100001', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE120010', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE120037', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE110004', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE120055', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE150003', 'classiqueG'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personnes'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'gite' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Gîte'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Gîte'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'sem'<br />Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Texte de présentation en'<br />Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='fr' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003' <br />Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='en' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003' <br />Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='it' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003' <br />Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='es' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003' <br />Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='nl' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003' <br />Select texteintrog FROM [chambre/languetxt] with(nolock) where isnull(tradautog,0) = 0 AND idlang='de' AND isnull(texteintrog,'') <> '' AND [code chambre] Like 'BE150003' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE150002', 'classiqueG'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personnes'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'gite' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Gîte'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Gîte'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'sem'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE120006', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BE130019', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />SELECT TOP 1 numlieu from LieuxStats where numlieu like '5628' and [moiscourant] like '19/04' <br />UPDATE LieuxStats SET [ANGnbconn]= [ANGnbconn]+1 WHERE numlieu like '5628' and [moiscourant] like '19/04'<br />SELECT libelle FROM descriptions with(nolock) WHERE ISNULL(libelle,'') <> '' AND  idlang='en' AND libtype='lieux' AND idtype = '5628' AND statut = 1  <br />Select url,titre FROM photos with(nolock) WHERE idtype = '5628' AND statut = 1 AND libtype='lieux' order by principale desc<br />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' <br />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||'<br />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||'<br />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')<br /> <font face="Arial" size=2>
<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial" size=2>erreur '80040e07'</font>
<p>
<font face="Arial" size=2>[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.</font>
<p>
<font face="Arial" size=2>/fonctions_asp/fonction-likhom-bd.asp</font><font face="Arial" size=2>, ligne 18</font>