Revision info - Quarry

SQL

use hewiki_p;
SELECT page_id, page_title, rev_id, rev_comment, rev_user_text, rev_user, rev_timestamp, rev_parent_id, old_id, old_text, old_flags
FROM page Inner Join revision Inner Join text 
ON rev_id = old_id
AND page_id = rev_page
WHERE page_namespace = 0
AND page_len > 1000
AND page_is_redirect = 0
AND rev_minor_edit = 0
AND rev_deleted = 0
AND rev_user NOT LIKE '%Bot'
#ORDER BY page_len ASC
LIMIT 100;

#http://quarry.wmflabs.org/query/871
# use iswiki_p;
#SELECT page_title, page_len FROM page
#WHERE page_namespace = 0
#AND page_len < 1000
#AND page_is_redirect = 0
#AND page_id NOT IN (
#  SELECT pp_page FROM page_props WHERE pp_propname IN ('disambiguation')
#  )
#AND page_id NOT IN (
#  SELECT tl_from FROM templatelinks WHERE tl_title IN ('Stubbur')
#  )
#ORDER BY page_len ASC LIMIT 300;
SQL

Checking query status...
