Untitled query #86860

SQL

SELECT SQL_SMALL_RESULT
       MAX(rev_timestamp) AS lastedit, 
       COUNT(rev_id) AS editcount, 
       page_title
FROM revision,
     -- This inner query returns the 500 pages with the earliest timestamps on their latest revisions
     (SELECT rev_timestamp AS lastedit, page_id, page_title
      FROM page, revision
      WHERE page_id IN
          -- This query returns the list of regular articles created earlier than page_id X
          (SELECT page_id
           FROM page
           WHERE page_namespace = 0
             AND page_is_redirect = 0
             AND NOT EXISTS (SELECT 1 
                             FROM page_props 
                             WHERE pp_page = page_id 
                               AND pp_propname = 'disambiguation')
             AND page_id < 21000000
             -- Big heuristic to ignore articles created after Dec 2008
             -- Adjust this if you get fewer than 500 results
          )
        AND rev_id = page_latest
        AND NOT EXISTS (SELECT 1 
                        FROM categorylinks cl
                        WHERE cl.cl_from = page_id
                          AND (cl.cl_to = 'Wikipedia_interwiki_soft_redirects'
                               OR cl.cl_to IN 
                                 (SELECT cl_to 
                                  FROM categorylinks subcat
                                  WHERE subcat.cl_to LIKE 'Wikipedia_interwiki_soft_redirects%')))
      ORDER BY lastedit ASC
      LIMIT 500
     ) AS InnerQuery
WHERE rev_page = page_id
GROUP BY page_id
ORDER BY lastedit ASC;
SQL

Checking query status...
