| use enwikisource_p;
SELECT CONCAT(log_type, '-', log_action) AS source,... |
7 years ago |
| use enwikisource;
SELECT CONCAT(log_type, '-', log_action) AS source,... |
7 years ago |
| SELECT rev_id, rev_timestamp, UNIX_TIMESTAMP(rev_timestamp) AS... |
7 years ago |
| SELECT rev_id, rev_timestamp, UNIX_TIMESTAMP(rev_timestamp) AS... |
7 years ago |
| USE enwiki_p;
SELECT page_namespace, COUNT(rev_id) AS total
FROM... |
7 years ago |
| USE enwiki_p;
select distinct page_namespace
from page_assessments join page... |
7 years ago |
| USE enwiki_p;
select page_namespace, count(*)
from page_assessments join... |
7 years ago |
| USE enwiki_p;
select distinct page_namespace from (select * from... |
7 years ago |
| USE enwiki_p;
select page_namespace, count(*)
from page_assessments join... |
7 years ago |
| USE enwiki_p;
explain select page_namespace, count(*)
from page_assessments... |
7 years ago |
| USE enwiki_p;
select page_namespace, count(*)
from page_assessments join... |
7 years ago |
| USE enwiki_p;
select count(*) from page_assessments; |
7 years ago |
| show databases like '%wp%' |
7 years ago |
| show databases like '%wikipedia%' |
7 years ago |
| show databases; |
7 years ago |
| use enwikipedia_p; |
7 years ago |
