INSERT INTO service.service_static_url (human_url, default_url)
  SELECT
    t.human_url,
    t.default_url
  FROM (
    SELECT
      'discover/' || lower(replace(ddcountry.name, ' ', '_')) as human_url,
      'country/view?id=' || ddcountry.id as default_url
    FROM dict.dict_country ddcountry

  UNION ALL

    SELECT
      t.human_url,
      'region/view?id=' || t.id as default_url
    FROM (
      SELECT
        human_url,
        max(id) as id
      FROM (
        SELECT
            'discover/' || lower(replace(country.name, ' ', '_')) || '/'  || lower(replace(region.name, ' ', '_')) as human_url,
            region.id
          FROM dict.dict_region region
          JOIN dict.dict_country country ON country.id = region.country_id
      ) t
      GROUP BY human_url
    ) t

  UNION ALL

    SELECT
      t.human_url,
      'divesite/view?id=' || t.id as default_url
    FROM (
      SELECT
        human_url,
        max(id) as id
      FROM (
        SELECT
            'discover/' || lower(replace(country.name, ' ', '_')) || '/'  || lower(replace(divesite.name, ' ', '_')) as human_url,
            divesite.id
          FROM ds.ds_divesite divesite
          JOIN dict.dict_country country ON country.id = divesite.country_id
      ) t
      GROUP BY human_url
    ) t
  ) t