#1525 Find titles w/out the Tr template whose pubs have this template

[Ahasuerus]

Create a new cleanup report to look for titles which do not have the "Tr" template in the Notes field but at least one of their associated publications has this template in Notes. The proposed SQL query is as follows:

select distinct(t.title_id) from titles t, pubs p, pub_content pc, notes n_t, notes n_p where t.title_id=pc.title_id and p.pub_id=pc.pub_id and t.note_id=n_t.note_id and n_t.note_note not like '%{{Tr|%' and p.note_id=n_p.note_id and n_p.note_note like '%{{Tr|%' and t.title_ttype=p.pub_ctype;

[Ahasuerus]

Implemented as a weekly report in:

edit/cleanup_lib.py
edit/cleanup_report.py
nightly/translations_cleanup.py

Installed in SVN 973 on 2022-08-23. Closing the FR.