ISFDB talk:Collections with Multiple Collections in

Omnibuses of Collections should be Omnibus type, not a bigger Collection. Although some of these look as they may be a Collection containing itself and a variant of itself. BLongley 16:09, 30 April 2011 (UTC)

SQL:

select "[http://www.isfdb.org/cgi-bin/pl.cgi?", z.pub_id, " ", z.pub_title, "] <br> " from ( select p.pub_id, p.pub_title, count(*) from pubs p, pub_content pc, titles t where pc.pub_id = p.pub_id and p.pub_ctype = 'COLLECTION' and pc.title_id = t.title_id and t.title_ttype = 'COLLECTION' GROUP BY p.pub_id, p.pub_title HAVING count(*) > 1 ) z