Untitled query #68433

SQL

-- SELECT MAX(rev_id),page.* from page, revision where rev_page=page_id AND page_id IN (19954682,9483596,61880941,59260817,31563700,25109587) GROUP BY page_id;

-- SELECT * FROM revision r, revision p WHERE r.rev_page=24176 AND r.rev_deleted=0 AND p.rev_deleted=0 AND
-- r.rev_timestamp < 20150000000000 AND r.rev_parent_id=p.rev_id ORDER BY r.rev_timestamp DESC LIMIT 1;

SELECT * FROM revision r, revision p WHERE r.rev_page=24176 AND r.rev_deleted=0
AND p.rev_deleted=0 AND r.rev_parent_id=p.rev_id LIMIT 10;
SQL

Checking query status...
