Possible BLPPROD candidates

To do:
-Add timestamps for created/last edited
-Create crawler bot to filter out articles that have ref sections (and post results to a wiki user page)

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/', p.page_title) AS 'Page', COUNT(el.el_id) AS 'External link count', MAX(p.page_len) AS 'Length', TIMESTAMP(MIN(r.rev_timestamp)) AS 'Created'
FROM page p
LEFT JOIN externallinks el ON p.page_id = el.el_from
INNER JOIN revision r ON p.page_id = r.rev_page
WHERE p.page_namespace = 0
AND p.page_is_redirect = 0
AND p.page_id IN (
  SELECT cl.cl_from FROM
  enwiki_p.categorylinks cl
  WHERE cl.cl_to = 'Living_people'
)
GROUP BY p.page_title
HAVING COUNT(el.el_id) = 0
ORDER BY MAX(p.page_len) ASC
LIMIT 1000

SQL

Checking query status...