Wikinews use counts

SQL

SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND page_links_updated < 20150101000000
AND page_id NOT IN (SELECT pp_page
                    FROM page_props
                    WHERE pp_propname = 'disambiguation')
AND page_id NOT IN (SELECT DISTINCT cl_from
                    FROM categorylinks
                    WHERE cl_to IN ('All_set_index_articles',
                                    'Given_names',
                                    'Surnames',
                                    'All_orphaned_articles',
                                    'All_redirects_for_discussion',
                                    'Candidates_for_undeletion',
                                    'All_stub_articles')
                   OR cl_to LIKE 'Redirects_to_%'
                   OR cl_to LIKE '%_given_names')
LIMIT 100
SQL

Checking query status...
