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 C.[code chambre] FROM chambres C WITH(NOLOCK) INNER JOIN villesmonde V WITH(NOLOCK) ON C.idville = V.[code ville] WHERE replace(replace(replace(replace(replace(C.[nom domaine],'-',' '),'''',' '),'''',' '),'°',' '),'&',' and ') LIKE 'gites et chambres d hotes du maarif' COLLATE French_CI_AI AND V.[nomvilleen] LIKE 'grandvillers' COLLATE French_CI_AI AND C.statut IN('G','A','B','C','D','R','S','X','N','V','VR','VS','Z','I','AI') SELECT Top 1 CP.id FROM [chambre/produits] CP with(nolock) inner join chambres C on CP.[code chambre] = C.[code chambre] where CP.[code chambre]='AL8809002' AND (statut_produit=1 or (statut_produit<>1 and C.statut = 'N')) SELECT TOP 1 C.prixjour, C.prixsemaine, C.pays, C.devise, C.capgitee, C.languecom,C.avis,C.mdp,C.capgitea,C.[chnb], C.[chtjemin], C.[chtsemin], C.[chtjemax], C.[chtsemax], C.[chlse], C.[chpd], C.[chautre], C.[sunb], C.[sutjemin], C.[sutsemin], C.[sutjemax], C.[sutsemax], C.[sulse], C.[supd], C.[suautre], C.[apnb], C.[aptjemin], C.[aptsemin], C.[aptjemax], C.[aptsemax], C.[aplse], C.[appd], C.[apautre], C.[manb], C.[matjemin], C.[matsemin], C.[matjemax], C.[matsemax], C.[malse], C.[mapd], C.[maautre], C.itineraire,C.[date mise en ligne],C.datemodif,C.datemesspersog,C.datemesspersoc,C.indicportable,C.indicfax,C.indictel,C.portable,C.fax,C.tel, C.statut,C.[code chambre],C.[type],C.[département],C.[email], C.[siteok],C.[adresse siteg],C.[adresse site], C.[nom domaine],C.[lat],C.[lng],C.[ville],C.[nom proprio],C.[codpost],C.[adresse],V.[nomvilleen],C.idville,C.sms,C.portablesms FROM chambres C with(NOLOCK) INNER JOIN villesmonde V with(NOLOCK) ON C.idville = V.[code ville] where C.[code chambre]='AL8809002' and C.statut IN ('G','A','B','C','D','R','S','X','N','V','VR','VS','Z','I','AI') SELECT id FROM moderateurs with(nolock) where email = 'carulla@wanadoo.fr' and testeur='True' SELECT [nompaysen] FROM pays P with(nolock) INNER JOIN régionmonde R with(nolock) ON P.code = R.pays INNER JOIN départementmonde D with(nolock) ON R.id = D.idreg where D.id ='88' SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK) WHERE fr= 'chambre_hotes' Select R.[code reg], P.actifreg, R.actifdep, P.code, D.[nomdepen], R.[nomregen],D.id as iddep, R.[id], P.[nompaysen], V.[nomvilleen] FROM villesmonde V WITH (nolock) 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.[code ville] = '38036' AND D.[id] = '88' 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= 'Valider votre opinion' SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Envoyer' SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hôtes de charme ||nomdomaine|| à ||ville||' SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Réservez votre séjour en chambre d''hôtes de charme à ||ville|| dans la région ||region|| : photos, avis, contact, etc. ' SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'Chambre d''hotes' SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'hebergement hotel de charme' SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'chambre d''hote de charme' SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK) WHERE francais= 'chambres d''hotes' Charming Bed and Breakfast Gites et Chambres d Hotes du Maarif in Grandvillers
Select TOP 1 CP.nomfichier, CP.titrefichier, C.[département] from [chambre/photos] CP with(nolock) INNER JOIN chambres C with(nolock) ON CP.[code chambre] = C.[code chambre] where CP.verif=1 AND CP.[code chambre] = 'AL8809002' AND CP.[type] = 'C' ORDER BY CP.ordre
