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