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... |
8 years ago |
USE enwiki_p;
select page_namespace, count(*)
from page_assessments join... |
8 years ago |
USE enwiki_p;
select distinct page_namespace from (select * from... |
8 years ago |
USE enwiki_p;
select page_namespace, count(*)
from page_assessments join... |
8 years ago |
USE enwiki_p;
explain select page_namespace, count(*)
from page_assessments... |
8 years ago |
USE enwiki_p;
select page_namespace, count(*)
from page_assessments join... |
8 years ago |
USE enwiki_p;
select count(*) from page_assessments; |
8 years ago |
show databases like '%wp%' |
8 years ago |
show databases like '%wikipedia%' |
8 years ago |
show databases; |
8 years ago |
use enwikipedia_p; |
8 years ago |