Find first edits for articles with langlinks

SQL

SELECT page_id, page_title, rev_page, rev_id , rev_timestamp, rev_user_text, ll_title
FROM
(SELECT ll_from, ll_title FROM hewiki_p.langlinks
 	WHERE ll_lang ='en'
	AND ll_title != "") as helinks
INNER JOIN
(SELECT * From hewiki_p.page 
	WHERE page_namespace = 0
	AND page_len > 1000
	AND page_is_redirect = 0) as page
ON ll_from = page.page_id
Inner Join
(Select rev_page, rev_id , rev_timestamp, rev_user_text 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 revision
ON page_id = rev_page
#ORDER BY page_len ASC
LIMIT 100;

SQL

Checking query status...