SQL queries used for determining old-style multipolygon member information

distinct outer tags.sql

SELECT count(*), n_tags
  FROM (SELECT count(DISTINCT w.tags) AS n_tags
    FROM relations r
      JOIN relation_members rm ON (r.id=rm.relation_id)
      JOIN ways w ON (rm.member_type='W' AND rm.member_role='outer' AND rm.member_id=w.id)
    WHERE r.tags=hstore('type','multipolygon')
    GROUP BY r.id) AS s
  GROUP BY n_tags
  ORDER BY n_tags;

list relations.sql

COPY (SELECT count(DISTINCT w.tags) AS n_tags, r.id, ST_AsText(ST_MakeLine(w.linestring))
  FROM relations r 
    JOIN relation_members rm ON (r.id=rm.relation_id)
    JOIN ways w ON (rm.member_type='W' AND rm.member_role='outer' AND rm.member_id=w.id)
  WHERE r.tags=hstore('type','multipolygon') 
  GROUP BY r.id
  HAVING count(DISTINCT w.tags) >= 2
  ORDER BY n_tags DESC) TO STDOUT;