Hebrew articles that are candidates to be a translation

SQL

SELECT hepage_id, hepage_title, herev_id, he_timestamp, enpage_id, enpage_title, enrev_id, 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 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
GROUP BY enpage_id
#HAVING en_timestamp = MAX(en_timestamp)
;
SQL

Checking query status...
