Untitled query #1823

SQL

 
SELECT DISTINCT COUNT(enpage_id) FROM
(SELECT page_id as hepage_id, page_title as hepage_title, rev_id as herev_id, rev_timestamp as he_timestamp, ll_title
 FROM
 (SELECT ll_from, ll_title FROM hewiki_p.langlinks
  WHERE ll_lang ='en'
  AND ll_title != "") as helang
 INNER JOIN
 (SELECT page_id, page_title FROM hewiki_p.page 
  WHERE page_namespace = 0
  AND page_len > 1000
  AND page_is_redirect = 0) as hepage
 ON ll_from = page_id
 INNER JOIN
 (SELECT rev_page, rev_id, rev_timestamp FROM hewiki_p.revision
  WHERE rev_minor_edit = 0
  AND rev_deleted = 0
  AND rev_user NOT LIKE '%Bot'
  AND rev_parent_id = 0) as herevision
 ON page_id = rev_page) as he_articles
Inner Join
(SELECT page_id as enpage_id, page_title as enpage_title, rev_id as enrev_id, rev_timestamp as en_timestamp From enwiki_p.page
 INNER JOIN enwiki_p.revision
 ON page_id = rev_page
 WHERE page_namespace = 0
 AND rev_deleted = 0) as en_articles
ON ll_title = enpage_title
AND he_timestamp > en_timestamp
;
SQL

Checking query status...
