SELECT
user_name,
log_namespace,
log_timestamp,
log_action,
... |
7 years ago |
DESCRIBE enwiki_p.recentchanges; |
7 years ago |
SELECT * FROM recentchanges change_tag as a JOIN revision ON rev_id =... |
7 years ago |
SELECT * FROM change_tag as a JOIN revision ON rev_id = a.ct_rev_id WHERE... |
7 years ago |
SELECT FROM change_tag as a JOIN revision ON rev_id = a.ct_rev_id WHERE... |
7 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
7 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
7 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
7 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
7 years ago |
SELECT
SUBSTR(rev_timestamp, 1, 6) AS MONTH,
COUNT(rev_id) AS edits
FROM... |
7 years ago |
DESCRIBE enwiki_p.revision; |
7 years ago |
DESCRIBE enwiki_p.page_props; |
7 years ago |
select * from valid_tag where vt_tag = 'ContentTranslation'; |
7 years ago |
DESCRIBE enwiki_p.valid_tag; |
7 years ago |
select * from change_tag where ct_tag = 'ContentTranslation#'; |
7 years ago |
DESCRIBE enwiki_p.change_tag; |
7 years ago |
DESCRIBE enwiki_p.revision; |
7 years ago |
DESCRIBE enwiki_p.page; |
7 years ago |
DESCRIBE enwiki_pl.page; |
7 years ago |
DESCRIBE nlwiki_p.page; |
7 years ago |