|
Events
in the mountains of the French Riviera
|
Festivals of winter sports, traditional celebrations, skiing races, athletic competitions… find the complete calendar of events and festivities in the Alpes-Maritimes ski resorts. |
| |
|
Warning: mssql_query() [function.mssql-query]: message: Nom de colonne non valide : 'EN'. (severity 16) in E:\CRT_SITES\commun\inc\fonctions.php on line 259
Warning: mssql_query() [function.mssql-query]: Query failed in E:\CRT_SITES\commun\inc\fonctions.php on line 259
SELECT DISTINCT OBJET_TF.ID, OBJET_TF.SOCIETE,OUVERTURE.IMPRECIS, OUVERTURE.DAT_DEBUT_OUVAC, OUVERTURE.DAT_FIN_OUVAC, COMMUNE.AGREGAT, COMMUNE.NOM_COMMUNE, OBJET_TF.ETAT, OBJ_TF_INFO.NOM_FMA, CASE CATEGORIE_CLASSEMENT.CAT_CLASS_CODE_OBJ WHEN 'EXPOS' THEN '1' ELSE '0' END AS CATEG 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.MONTAGNE_HIVER='1' AND NOM_COMMUNE !=''
AND OUVERTURE.DAT_FIN_OUVAC >= '24/05/2013' AND ADRESSE.ID_COMMUNE IN (149,147,96,72,99,99,142,203,64,65,71,169,170,87,79,68,148,206,104,207,102,105,84,75,74) AND OBJET_TF.ID IN(SELECT ID FROM THEME WHERE OBJCON_ID='659') AND CAT_CLASS_CODE_OBJ IN (EN) ORDER BY CATEG, OUVERTURE.DAT_DEBUT_OUVAC
| | |
