|
Accueil >
Warning: mssql_query() [function.mssql-query]: message: Syntaxe incorrecte vers '='. (severity 15) in E:\CRT_SITES\commun\inc\fonctions.php on line 228
Warning: mssql_query() [function.mssql-query]: Query failed in E:\CRT_SITES\commun\inc\fonctions.php on line 228
Warning: mssql_fetch_object(): supplied argument is not a valid MS SQL-result resource in E:\CRT_SITES\commun\inc\fonctions.php on line 231
>
Warning: mssql_query() [function.mssql-query]: message: Syntaxe incorrecte vers '='. (severity 15) in E:\CRT_SITES\commun\inc\fonctions.php on line 228
Warning: mssql_query() [function.mssql-query]: Query failed in E:\CRT_SITES\commun\inc\fonctions.php on line 228
SELECT DISTINCT OBJET_TF.ID, OBJ_TF_INFO.NOM_FMA AS SOCIETE,OUVERTURE.IMPRECIS, OUVERTURE.DAT_DEBUT_OUVAC, OUVERTURE.DAT_FIN_OUVAC, COMMUNE.AGREGAT, COMMUNE.NOM_COMMUNE, OBJET_TF.ETAT, OBJ_TF_INFO.NOM_FMA
FROM OBJ_TF_INFO
RIGHT OUTER JOIN OBJET_TF
INNER JOIN FMA_SITE_WEB ON OBJET_TF.ID = FMA_SITE_WEB.ID ON OBJ_TF_INFO.ID = OBJET_TF.ID AND OBJ_TF_INFO.OBJ_TF_INFO_LANGUE = 'EN'
LEFT OUTER JOIN OUVERTURE ON OBJET_TF.ID = OUVERTURE.ID
LEFT OUTER JOIN OBJET_CONTENU_INFO INNER JOIN OBJET_CONTENU ON CAST(OBJET_CONTENU_INFO.CODE_NUM AS CHAR(50)) + OBJET_CONTENU_INFO.OBJ_CONT_LANG = CAST(OBJET_CONTENU.CODE_NUM AS CHAR(50)) + 'EN'
LEFT OUTER JOIN TYPE_PRINCIPAL ON OBJET_CONTENU.CODE = TYPE_PRINCIPAL.TYPE_CODE_OBJ ON OBJET_TF.ID = TYPE_PRINCIPAL.ID
LEFT OUTER JOIN CATEGORIE_CLASSEMENT ON OBJET_TF.ID = CATEGORIE_CLASSEMENT.ID LEFT OUTER JOIN COMMUNE
RIGHT OUTER JOIN ADRESSE ON COMMUNE.ID = ADRESSE.ID_COMMUNE ON OBJET_TF.ID = ADRESSE.ID
WHERE (OBJET_TF.ID_OBJETTOUR = 'FMA') AND (OBJET_TF.ETAT is null) AND FMA_SITE_WEB. ='1' AND NOM_COMMUNE !=''
AND OUVERTURE.DAT_FIN_OUVAC >= '08/02/2012' ORDER BY DAT_DEBUT_OUVAC
| |
Stays