Okresy nieaktywności Olafbota w plwiktionary

SQL

use plwiktionary_p;

# 23.02.2019 - 01.05.2019
select distinct page_title
from revision inner join page on page.page_id = rev_page
where page_namespace = 0 and rev_timestamp > 20190223000000 and rev_timestamp < 20190501000000
;

# 15.01.2019 - 23.01.2019
select distinct page_title
from revision inner join page on page.page_id = rev_page
where page_namespace = 0 and rev_timestamp > 20190115000000 and rev_timestamp < 20190123000000
;

# 16.02.2018 - 01.03.2018
select distinct page_title
from revision inner join page on page.page_id = rev_page
where page_namespace = 0 and rev_timestamp > 20180216000000 and rev_timestamp < 20180301000000
;

# 11.07.2017 - 20.07.2017
select distinct page_title
from revision inner join page on page.page_id = rev_page
where page_namespace = 0 and rev_timestamp > 20170711000000 and rev_timestamp < 20170720000000
;

# 29.06.2016 - 13.07.2016
select distinct page_title
from revision inner join page on page.page_id = rev_page
where page_namespace = 0 and rev_timestamp > 20160629000000 and rev_timestamp < 20160713000000
;

# 30.06.2015 - 13.07.2015
select distinct page_title
from revision inner join page on page.page_id = rev_page
where page_namespace = 0 and rev_timestamp > 20150630000000 and rev_timestamp < 20150713000000
;
SQL

Checking query status...
