|
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 |
