Championnat FFF ENTREPRISE - Samedi PH :: Classement Effectif
Requète SQL :
SELECT DATE_FORMAT(c.date, '%d/%m/%y') as date, IF(c.lieu='dom','FC BAC', IFNULL(e.equipe, '?')) as locaux, IF(c.date < CURDATE(), IF(c.lieu='dom', CONCAT(c.buts_pour,' - ',c.buts_contre), CONCAT(c.buts_contre,' - ',c.buts_pour) ), CONCAT('-') ) AS score, IF(c.lieu='dom', IFNULL(e.equipe, '?'),'FC BAC') as visiteurs, CONCAT('journee.php?saison=1617&page=' , IF(c.date < CURDATE(), 'resume', 'prochain') , '&id_calendrier=',c.id_calendrier) AS popup_voir FROM calendrier1617 AS c LEFT JOIN equipes AS e ON c.id_adversaire=e.id_equipes WHERE c.type='ch' AND c.equipe='premiere' ORDER BY c.date
Message d'erreur :
Table 'ocblkfcbutt.calendrier1617' doesn't exist