SELECT min(date) FROM competition c, categorie_competition cc
WHERE c.id = cc.competition_id
AND date>'2025-01-15' SELECT distinct c.id FROM competition c, categorie_competition cc
WHERE c.id = cc.competition_id AND date>='2025-01-18'
ORDER by date, libelle
LIMIT 0, 3