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