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) = '2008' AND date >= NOW() GROUP BY `calendrier`.`id` ORDER BY `type desc` : Champ 'type desc' inconnu dans order clause