1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
SELECT MENU.Menu, PlatD1, PlatD2
FROM
(
SELECT DISTINCT libelle AS Menu
FROM Menus_Principaux
) MENU
LEFT JOIN
(
SELECT DAY1_NON_CONCAT.Menu AS Menu, GROUP_CONCAT(DISTINCT DAY1_NON_CONCAT.PlatD1 SEPARATOR " \n ") AS PlatD1
FROM
( SELECT CMPD.libelle AS Menu, CONCAT(" O ", GROUP_CONCAT(DISTINCT PlatD1 SEPARATOR " O ")) AS PlatD1
FROM Menus_Principaux M, Famille_Plat FP, Plat_Menu PM
WHERE PM.jointure = M.Jointure
AND FP.jointure = PM.jointure
AND PM.date='2010-01-18'
GROUP BY Menu, FP.libelle
) AS DAY1_NON_CONCAT
GROUP BY DAY1_NON_CONCAT.Menu
) DAY1 ON MENU.Menu = DAY1.Menu
LEFT JOIN
(
SELECT DAY1_NON_CONCAT.Menu AS Menu, GROUP_CONCAT(DISTINCT DAY1_NON_CONCAT.PlatD2 SEPARATOR " \n ") AS PlatD2
FROM
( SELECT CMPD.libelle AS Menu, CONCAT(" O ", GROUP_CONCAT(DISTINCT PlatD2 SEPARATOR " O ")) AS PlatD2
FROM Menus_Principaux M, Famille_Plat FP, Plat_Menu PM
WHERE PM.jointure = M.Jointure
AND FP.jointure = PM.jointure
AND PM.date='2010-01-19'
GROUP BY Menu, FP.libelle
) AS DAY1_NON_CONCAT
GROUP BY DAY1_NON_CONCAT.Menu
) DAY2 ON MENU.Menu = DAY2.Menu
WHERE PlatD1 IS NOT NULL
OR PlatD2 IS NOT NULL |
Partager