| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
8 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
8 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
9 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
9 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
9 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
9 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
9 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
10 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
10 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
11 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
11 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
11 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
12 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
12 months ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
1 year ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) = revert... |
2 years ago |
| SET @from = "20220720";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) revert... |
2 years ago |
| /*IP edits in a month: reverted and total*/
/*ct_tag_id in (58,59) revert... |
2 years ago |
| SET @from = "20220720";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220620";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220620";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220620";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220620";
SELECT *,(ct_tag_id in (58,59) as reverted) FROM... |
2 years ago |
| /*IP edits in a month: reverted and total*/
SET @from = "20220620";
SET @to ... |
2 years ago |
| /*IP edits in a month: reverted and total*/
SET @from = "20220620";
SET @to ... |
2 years ago |
| /*IP edits in a month: reverted and total*/
SET @from = "20220520";
SET @to ... |
2 years ago |
| /*IP edits in a month: reverted and total*/
SET @from = "20220520";
SET @to ... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200320";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200320";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200420";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200620";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200720";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200820";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200920";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20201020";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20201120";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20201220";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220320";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20200320";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210320";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210220";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210120";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220120";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20211220";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20211120";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20211020";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220506123000";
SET @to = DATE_FORMAT(@from + INTERVAL 13.5... |
2 years ago |
| SET @from = "20220506120000";
SET @to = DATE_FORMAT(@from + INTERVAL 13.5... |
2 years ago |
| SET @from = "20211020";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210920";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210820";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210720";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210620";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20210420";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220220";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220320";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220420";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220720";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220620";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220520";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SET @from = "20220620";
SET @to = DATE_FORMAT(@from + INTERVAL 1 MONTH,... |
2 years ago |
| SELECT count(DISTINCT rev_id) /*, ct_tag_id in (58,59) as reverted*/ FROM... |
2 years ago |
| SELECT count(DISTINCT rev_id) /*, ct_tag_id in (58,59) as reverted*/ FROM... |
2 years ago |
| SELECT UNIQUE rev_id /*, ct_tag_id in (58,59) as reverted*/ FROM revision,... |
2 years ago |
| SELECT UNIQUE rev_id /*, ct_tag_id in (58,59) as reverted*/ FROM revision,... |
2 years ago |
| SELECT UNIQUE(rev_id) /*, ct_tag_id in (58,59) as reverted*/ FROM revision,... |
2 years ago |
| SELECT count(UNIQUE(rev_id)) /*, ct_tag_id in (58,59) as reverted*/ FROM... |
2 years ago |
| SELECT count(rev_id) /*, ct_tag_id in (58,59) as reverted*/ FROM revision,... |
2 years ago |
| SELECT * /*, ct_tag_id in (58,59) as reverted*/ FROM revision, change_tag,... |
2 years ago |
| SELECT count(*) /*, ct_tag_id in (58,59) as reverted*/ FROM revision,... |
2 years ago |
| SELECT count(*) /*, ct_tag_id in (58,59) as reverted*/ FROM revision,... |
2 years ago |
| SELECT count(*) /*, ct_tag_id in (58,59) as reverted*/ FROM revision,... |
2 years ago |
| SELECT *, ct_tag_id in (58,59) as reverted FROM revision, change_tag, actor,... |
2 years ago |
| SELECT ct_tag_id in (58,59), * FROM revision, change_tag, actor, page WHERE... |
2 years ago |
| SELECT ct_tag_id in (58,59), * FROM revision, change_tag, actor, page WHERE... |
2 years ago |
| SELECT ct_tag_id in (58,59) as reverted, * FROM revision, change_tag, actor,... |
2 years ago |
| SELECT *, ct_tag_id in (58,59) FROM revision, change_tag, actor, page WHERE... |
2 years ago |
| SELECT * FROM revision, change_tag, actor, page WHERE
rev_id =... |
2 years ago |
| SELECT * FROM revision, change_tag, actor WHERE
rev_id = ct_rev_id
AND... |
2 years ago |
| SELECT * FROM revision, change_tag, actor WHERE
rev_id = ct_rev_id
AND... |
2 years ago |
| SELECT * FROM revision, change_tag, actor WHERE rev_id = ct_rev_id AND... |
2 years ago |
| SELECT * FROM revision, change_tag, actor WHERE rev_id = ct_rev_id AND... |
2 years ago |
| SELECT * FROM revision, change_tag WHERE rev_id = ct_rev_id AND rev_page =... |
2 years ago |
| SELECT * FROM revision, change_tag WHERE rev_id = ct_rev_id AND rev_id <... |
2 years ago |
| SELECT * FROM revision, change_tag WHERE rev_id = ct_rev_id AND rev_id <... |
2 years ago |
| SELECT * FROM revision, change_tag WHERE rev_id = ct_rev_id AND rev_id <... |
2 years ago |
| SELECT * FROM revision, change_tag WHERE rev_id = ct_rev_id ORDER BY... |
2 years ago |
| SELECT * FROM revision, change_tag WHERE rev_id = ct_rev_id AND ct_tag_id IN... |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id IN (7, 58, 59) ORDER BY ct_rev_id... |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id in [58, 59] ORDER BY ct_rev_id DESC... |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id = 58 ORDER BY ct_rev_id DESC LIMIT 150 ; |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id = 58 ORDER BY ct_rev_id LIMIT 150 ; |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id = 58 LIMIT 150 ORDER BY ct_rev_id; |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id = 58 LIMIT 150 ORDER BY ct_rev_id DESC; |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id = 58 LIMIT 150 ; |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id = 58 LIMIT 150 DESC; |
2 years ago |
| SELECT * FROM change_tag WHERE ct_tag_id = 58 LIMIT 150; |
2 years ago |
| SELECT * FROM change_tag LIMIT 150; |
2 years ago |
| SELECT * FROM change_tag_def LIMIT 150; |
2 years ago |
| SELECT * FROM change_tag LIMIT 150; |
2 years ago |
| SELECT * FROM change_tag DESC LIMIT 150; |
2 years ago |
| SELECT * FROM revision WHERE rev_actor=12 AND rev_timestamp > ... |
2 years ago |
| SELECT * FROM revision WHERE rev_timestamp > "20220810120000" LIMIT 150; |
2 years ago |
| SELECT * FROM revision WHERE rev_timestamp > "20220810120000" LIMIT 5; |
2 years ago |
| SELECT * FROM revision WHERE rev_deleted=0 AND rev_timestamp > ... |
2 years ago |
| SELECT * FROM revision WHERE rev_deleted=1 AND rev_timestamp > ... |
2 years ago |
| SELECT * FROM revision WHERE rev_deleted=1 AND rev_timestamp > "20220812" LIMIT 5; |
2 years ago |
| SELECT * FROM revision WHERE rev_deleted=1 LIMIT 5; |
2 years ago |
| SELECT * FROM revision LIMIT 5; |
2 years ago |
