Agenda canin: Liste/Recherche des évênements (Base de 1156 évênements proches)
Erreur: Echec d'une procedure
Merci de signaler cette erreur en envoyant cette page à webmaster@chiensderace.com
Erreur = Unable execute query:1054, Unknown column 'T_MANIFESTATIONS.ID_MANIF' in 'on clause'
Procedure = liste_manifs.pl
Date = 04/07/2009 - 14:13:10
Requete = select T_MANIFESTATIONS.ID_MANIF,LIB_MANIF,DATE_DEBUT_MANIF,VILLE_LIEU_MANIF,T_MANIFESTATIONS.PAYS_LIEU_MANIF,LIB_TYPES,TEL_MANIF,PUB_MANIF,LIB_RACES,LIB_REGIONS from T_MANIFESTATIONS, T_TYPES_MANIFESTATIONS, T_DEPARTEMENTS, T_REGIONS left join T_ASSOC_MANIFESTATION on T_ASSOC_MANIFESTATION.ID_MANIF = T_MANIFESTATIONS.ID_MANIF left join T_RACES on T_ASSOC_MANIFESTATION.ID_RACES = T_RACES.ID_RACES where T_MANIFESTATIONS.PAYS_LIEU_MANIF = 'FRANCE' and T_MANIFESTATIONS.REGION_ID_REGIONS is NULL and T_MANIFESTATIONS.CODEPOSTAL_MANIF like concat(T_DEPARTEMENTS.ID_DEPARTEMENTS,'%') and T_DEPARTEMENTS.REG_ID_REGIONS = T_REGIONS.ID_REGIONS and T_MANIFESTATIONS.TYPE_MANIF = T_TYPES_MANIFESTATIONS.ID_TYPES and DATE_DEBUT_MANIF >= '2009-07-04' and DATE_DEBUT_MANIF <= '2009-09-04' union select T_MANIFESTATIONS.ID_MANIF,LIB_MANIF,DATE_DEBUT_MANIF,VILLE_LIEU_MANIF,T_MANIFESTATIONS.PAYS_LIEU_MANIF,LIB_TYPES,TEL_MANIF,PUB_MANIF,LIB_RACES,LIB_REGIONS from T_MANIFESTATIONS, T_TYPES_MANIFESTATIONS left join T_REGIONS on T_REGIONS.ID_REGIONS = T_MANIFESTATIONS.REGION_ID_REGIONS left join T_ASSOC_MANIFESTATION on T_ASSOC_MANIFESTATION.ID_MANIF = T_MANIFESTATIONS.ID_MANIF left join T_RACES on T_ASSOC_MANIFESTATION.ID_RACES = T_RACES.ID_RACES where (T_MANIFESTATIONS.PAYS_LIEU_MANIF != 'FRANCE' or T_MANIFESTATIONS.REGION_ID_REGIONS is not NULL) and T_MANIFESTATIONS.TYPE_MANIF = T_TYPES_MANIFESTATIONS.ID_TYPES and DATE_DEBUT_MANIF >= '2009-07-04' and DATE_DEBUT_MANIF <= '2009-09-04' order by DATE_DEBUT_MANIF
