SELECT
epicside2020_epic_regions.id,
epicside2020_epic_regions.uid,
epicside2020_epic_regions.region_fr,
epicside2020_epic_countries.id,
epicside2020_epic_countries.uid,
epicside2020_epic_countries.code,
epicside2020_epic_countries.country_fr
FROM epicside2020_epic_countries
INNER JOIN epicside2020_epic_regions
ON epicside2020_epic_countries.region_id = epicside2020_epic_regions.id WHERE epicside2020_epic_countries.visible = 1 ORDER BY epicside2020_epic_regions.region_fr, epicside2020_epic_countries.country_fr