SELECT calendrier.*,
UNIX_TIMESTAMP(date)-UNIX_TIMESTAMP(NOW()) AS futur,
YEAR(date) AS year,
DATE_FORMAT(calendrier.date,'%d/%m') AS datef,
calendrier.nom as nomEvenement,
associations.tel1,
associations.email,
associations.nom AS nomClub,
prefixe,
commune,
communes.lat2,
communes.lon2,
`catalogue`.`id` AS `id_catalogue`,
`catalogue`.`etat` AS `etat_catalogue`,
`catalogue`.`stock`,
UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`catalogue`.`date_d`) AS `start_ok`,
UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`catalogue`.`date_f`) AS `end_ok`
FROM calendrier
LEFT JOIN associations ON associations.id = calendrier.idassos
LEFT JOIN communes ON communes.id = calendrier.id_communes
LEFT JOIN `catalogue` ON `catalogue`.`id_calendrier` = `calendrier`.`id`
WHERE YEAR(calendrier.date) = '2009' AND date >= NOW()
GROUP BY `calendrier`.`id`
ORDER BY `galerie desc` : Champ 'galerie desc' inconnu dans order clause