SELECT evAdr.event_UFI_code, c.se_date_debut 'date_debut', c.se_date_fin 'date_fin'
FROM ps_category c, ps_category_lang cl, ps_sport_event_adresses evAdr
WHERE c.id_category =
AND cl.id_category =
AND cl.id_lang = 4
AND c.id_adress = evAdr.id_adress