Query Run
SELECT page_title, page_id, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT page_title, page_id, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT page_title, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT count(distinct(rev_page)) FROM revision WHERE rev_timestamp BETWEEN... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revision WHERE rev_timestamp... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)) FROM revision WHERE rev_timestamp BETWEEN... 1 year ago
SELECT count(distinct(rev_page)) FROM revision WHERE rev_timestamp BETWEEN... 1 year ago
SELECT count(distinct(rev_page)) FROM revision WHERE rev_timestamp BETWEEN... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT * FROM revision LIMIT 2 1 year ago
SELECT * FROM revisions LIMIT 2 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... 1 year ago
SELECT rev_page, substring(rev_timestamp,1, 8)-- count(*) count_rev FROM... 1 year ago
SELECT rev_page, rev_timestamp-- count(*) count_rev FROM revision WHERE... 1 year ago
SELECT rev_page, count(*) FROM revision WHERE rev_timestamp BETWEEN... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revision WHERE rev_timestamp... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revision WHERE rev_timestamp... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
SELECT count(distinct(rev_page)), count(*) FROM revisions WHERE... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
SELECT (case when rev_timestamp<='20220102000000' then 1 else 0 end) a,... 1 year ago
SELECT (case when rev_timestamp<='20220102000000' then 1 else 0 end) a,... 1 year ago
SELECT (case when rev_timestamp<='20220102000000' then 1 else 0 end) a,... 1 year ago
SELECT rev_timestamp<='20220102000000', * FROM revision WHERE rev_page=69654137 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
SELECT * FROM revision WHERE rev_page=69654137 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
# #len of article (total - month - week - day before, same), page... 1 year ago
show tables 1 year ago
SELECT * FROM page_props LIMIT 100; 1 year ago
SELECT * FROM watchlist LIMIT 100; 1 year ago
SELECT * FROM watchlist_count LIMIT 100; 1 year ago
show tables; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist_count LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MIN(rev_timestamp) FROM watchlist LIMIT 100; 1 year ago
SELECT MAX(rev_timestamp), MIN(rev_timestamp) FROM revision LIMIT 100; 1 year ago
SELECT MAX(rev_timestamp), MIN(rev_timestamp) FROM revision WHERE rev_page = 1; 1 year ago
SELECT * FROM prop LIMIT 100; 1 year ago
SELECT * FROM prop LIMIT 100; 1 year ago
SELECT * FROM properties LIMIT 100; 1 year ago
SELECT * FROM categorylinks LIMIT 100; 1 year ago
SELECT * FROM category LIMIT 100; 1 year ago
SELECT * FROM page LIMIT 100; 1 year ago
SELECT * FROM watchlist LIMIT 100; 1 year ago
SELECT * FROM watchlist LIMIT 100; 1 year ago
SELECT * FROM watchlist LIMIT 100; 1 year ago
SELECT * FROM watchlist LIMIT 100; 1 year ago
SELECT * FROM watchlist LIMIT 100; 1 year ago
SELECT page_title, page_id, page_len FROM page LIMIT 100; 1 year ago
SELECT * FROM page LIMIT 100; 1 year ago
SELECT el_from FROM page LIMIT 100; 1 year ago
SELECT * FROM externallinks LIMIT 100; 1 year ago
SELECT * FROM pagelinks LIMIT 100; 1 year ago
SELECT * FROM watchlist LIMIT 100; 1 year ago
SELECT * FROM revision LIMIT 100; 1 year ago
DESCRIBE revision; 1 year ago
DESCRIBE revision; 1 year ago