Untitled query #26169

SQL

USE enwiki_p;
SELECT * FROM revision WHERE rev_page = 12172683 ORDER BY rev_parent_id DESC;

SELECT * FROM revision WHERE rev_page = 12172683 AND rev_parent_id = 0 AND rev_user_text = 'Polbot';

SELECT * FROM revision WHERE rev_page = 12172683 AND rev_parent_id = 0 AND rev_user_text = 'Polbot'
AND EXISTS (SELECT 1 FROM revision WHERE rev_page = 12172683 AND rev_timestamp < 20180314000000 LIMIT 1);

SELECT * FROM revision WHERE rev_timestamp < 20170705154900 LIMIT 25
/*
SELECT
  rev_page,
  rev_comment
FROM revision
WHERE rev_page = 12172683
AND rev_parent_id = 0
AND rev_user_text = 'Polbot'
AND NOT (rev_comment LIKE '%edirect%'
	OR rev_comment LIKE '%congress%'
	OR rev_comment LIKE '%biography%'
	OR rev_comment LIKE '%{{WikiProject%'
	OR rev_comment LIKE '%genus category%');*/
SQL

Checking query status...
