SELECT
        ce.event_id,
        ce.poster_ext,
        ce.id AS c_id,
        cef.id AS slider_id,
        cef.slider_ext,
        cef.widget_slider_ext,
        te.alias,
        te.date_event,
        tec.title AS event_title,
        tvc.title AS venue_title,
        terc.title AS rubric_title
    FROM c_event_feutured AS cef
    LEFT JOIN c_event AS ce ON ( cef.event_id = ce.id )
    LEFT JOIN t_event AS te ON (te.id = ce.event_id)
    LEFT JOIN t_venue AS tv ON (tv.id = te.venue_id)
    LEFT JOIN t_ticket_type AS ttt ON (ttt.event_id = te.id)
    LEFT JOIN t_rubric_events AS tre ON (tre.event_id = ce.event_id)
    LEFT JOIN t_event_rubric_content AS terc ON (terc.id = tre.rubric_id AND terc.language_id = ".$GLOBALS['lng']['id'].")
    LEFT JOIN t_venue_content AS tvc ON (tvc.id = te.venue_id)
    LEFT JOIN t_event_content AS tec ON (tec.`id` = ce.event_id AND tec.`language_id` = 1)
    WHERE cef.date_start <= NOW() AND cef.date_end >= NOW()  AND te.active = '1' AND ttt.active = 1
    GROUP BY cef.event_id
    ORDER BY ce.event_id
    LIMIT 7