use dewiki_p;
SELECT
from_unixtime(UNIX_TIMESTAMP(SUBSTR(rev_timestamp,... |
8 years ago |
use dewiki_p;
SELECT
from_unixtime(UNIX_TIMESTAMP(SUBSTR(rev_timestamp,... |
8 years ago |
SELECT DISTINCT
rev_user_text,
user_editcount
FROM revision
LEFT JOIN... |
8 years ago |
SELECT
rev_page AS page_id,
count(*) ... |
8 years ago |
SHOW TABLES FROM dewiki_p; |
8 years ago |
Use enwiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |
Use dewiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |