Create a new cleanup report to find CHAPBOOKs with multiple fiction titles. The query logic should be:
select distinct p.pub_id from pubs p where pub_ctype='CHAPBOOK' and
(select count(t.title_id) from pub_content pc, titles t
where p.pub_id = pc.pub_id and pc.title_id = t.title_id
and t.title_ttype in ('SHORTFICTION', 'POEM', 'SERIAL')) > 1
Anonymous
Implemented in:
Installed in SVN 517 on 2020-04-25. Closing the FR.
Part 2 - Let moderators ignore records. Implemented in edit/cleanup_report.py, installed in SVN 525 on 2020-05-09. Keeping the FR closed.