gistfile1.txt

      SELECT r.id
       FROM musicbrainz.release_group rg
       JOIN musicbrainz.release r ON rg.id = r.release_group
       JOIN musicbrainz.release_country rc ON rc.release = r.id
       JOIN musicbrainz.medium m ON m.release = r.id
       JOIN musicbrainz.medium_format mf ON m.format = mf.id
       JOIN musicbrainz.format_sort fs ON mf.id = fs.format
FULL OUTER JOIN musicbrainz.release_group_secondary_type_join rgstj ON rg.id = rgstj.release_group
      WHERE rg.artist_credit != 1
   ORDER BY rg.artist_credit, rg.type, rgstj.release_group desc, rg.name, fs.sort, date_year, date_month, date_day, country