SELECT
E.*,
EL.designation AS location,
EA.designation AS area
FROM
EVENT E
LEFT JOIN
EVENT_AREA EA
ON
EA.area_id = E.area_id
LEFT JOIN
EVENT_LOCATION EL
ON
EL.location_id = E.location_id
WHERE
E.messe_id = '' AND
E.status_id = 1 AND
EA.status = 1
AND EA.area_id = 10
;
Programm | www.agra-messe.de