Hebrew articles that are candidates to be a translation

SQL

SELECT hepage_id, hepage_title, herev_id, he_timestamp, enpage_id, enpage_title, 
revision2.rev_id as enrev_id, max_en_timestamp as en_timestamp FROM (
  SELECT hepage_id, hepage_title, herev_id, he_timestamp, enpage_id, enpage_title, MAX(enrev_timestamp) as max_en_timestamp 
  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, REPLACE(ll_title, ' ','_') as ll_title FROM hewiki_p.langlinks
          WHERE ll_lang ='en'
          AND ll_title != ""
      	  LIMIT 100) 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 LCASE(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_timestamp as enrev_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 > enrev_timestamp
    GROUP BY enpage_id) as filtered
  INNER JOIN enwiki_p.revision as revision2
  ON filtered.enpage_id = revision2.rev_page
  AND filtered.max_en_timestamp = revision2.rev_timestamp
;
SQL

Checking query status...
