SELECT
                     se_id, se_date, ss_name, se_is_tour
                   FROM
                     site_event 
                     INNER JOIN site_event_spectacle USING(se_id)
                     INNER JOIN site_event_spectacle_translation USING(ss_id)
                   WHERE
                      ss_id IN (545,549,550,551,552,555,556,557,566,568,569,571,572,573,574,576,578,579,580,581,586,587,588,589,591,593,594,595,596,601,602,603,604,605,606,607,608,609,611,612,614,620,629,649,650,654,657,660,662,663,664,665,,678,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,706,708,709,710) and site_event_spectacle_translation.lang_id = '2' and se_is_active = 1 and se_date > NOW()
                   ORDER BY se_date ASC
                   LIMIT 7