Agenda canin: Liste/Recherche des évênements (Base de 1183 évênements proches)

Critères de recherche:

Filtre: Type d'évênement ou concours (Descriptif des types) - Tous - Filtre: Mot clé autre Filtre: Date A partir du jusqu'au

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 = 02/09/2010 - 16:39:26
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 >= '2010-09-02' and DATE_DEBUT_MANIF <= '2010-11-02' 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 >= '2010-09-02' and DATE_DEBUT_MANIF <= '2010-11-02' order by DATE_DEBUT_MANIF