SELECT DISTINCT(c.pays) as pays FROM event a LEFT JOIN event_structure b on (b.event_id=a.id) LEFT JOIN structure c on (c.id = b.structure_id) WHERE a.online=1 AND a.date_online <'2026-10-06 02:24:19' ORDER BY c.pays