CONNECTED BIOS. exploring urban culture

BIOS ATHENS - Athens centre for today's art and cross media

SELECT t1.int_event_id, str_title_gr, str_category_gr, str_title_en, str_category_en, str_event_image, str_color, MAX( event_date ) AS event_date, bln_homepage, bln_featured FROM event t1 LEFT JOIN event_date t2 ON t1.int_event_id = t2.int_event_id LEFT JOIN category t3 ON t1.int_category_id = t3.int_category_id WHERE bln_featured=1 GROUP BY t1.int_event_id