Untitled query #1825

SQL

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
;
SQL

Checking query status...
