Untitled query #69667

SQL

SELECT page.*, pagelinks.*, cl1.cl_to
FROM   page
LEFT JOIN   pagelinks ON pl_from = page_id
LEFT JOIN   categorylinks cl1 ON cl1.cl_from = page_id /* AND cl1.cl_to='Articles_with_no_corresponding_English_Wikipedia_article' */
LEFT JOIN   page_props pp1 ON pp1.pp_page = page_id AND pp1.pp_propname = 'wikibase_item'
WHERE  page_id IN 
               /* (SELECT rev_page 
                   FROM   revision
                   JOIN   page ON page_id = rev_page
                   WHERE  page_namespace = 0
                   AND    page_is_redirect = 0
                   AND    rev_timestamp > NOW() - INTERVAL 1 DAY
                  ) */
                  (SELECT rev_page
                   FROM   revision
                   JOIN   page p2 ON page_id = rev_page
                   WHERE  p2.page_namespace = 0
                   AND    p2.page_title in ('Richard_Maunsell', 'Mary_Muleebwa_Kamanzi')
                  GROUP BY rev_page
                  )
                
LIMIT 100
SQL

Checking query status...
