use enwiki_p;
select pa.page_title, min(substr(cl_cn.cl_to, -4, 4)) as... |
3 years ago |
use enwiki_p;
select pa.page_title, min(substr(cl_cn.cl_to, -4, 4)) as... |
3 years ago |
use enwiki_p;
select pa.page_title, min(substr(cl_cn.cl_to, -4, 4)) as... |
3 years ago |
use enwiki_p;
select pa.page_title, min(substr(cl_cn.cl_to, -4, 4)) as... |
3 years ago |
use enwiki_p;
select pa.page_title, min(substr(cl_cn.cl_to, -4, 4)) as... |
3 years ago |
use enwiki_p;
select pa.page_title, min(substr(cl_cn.cl_to, -1, 4)) as... |
3 years ago |
use enwiki_p;
select pa.page_title, min(cl_cn.cl_to) as cat
from page pa... |
3 years ago |
use enwiki_p;
select pa.page_title, min(cl_cn.cl_to) as cat
from page pa... |
3 years ago |
use enwiki_p;
select pa.page_title, min(cl.cl_to) as cat
from page pa... |
3 years ago |
use enwiki_p;
select pa.page_title, min(cl.cl_to) as cat
from page pa inner... |
3 years ago |
use enwiki_p;
select pa.page_title, cl.cl_to
from page pa inner join... |
3 years ago |
use enwiki_p;
select *
from page pa inner join categorylinks cl on... |
3 years ago |
use enwiki_p;
select count(*)
from page pa inner join categorylinks cl on... |
3 years ago |
use enwiki_p;
select count(*)
from page pa inner join categorylinks cl on... |
3 years ago |
use enwiki_p;
select count(*)
from page pa inner join category_links cl on... |
3 years ago |
use enwiki_p;
select count(*)
from page pa
where pa.page_namespace = 0 and... |
3 years ago |
use enwiki_p;
select count(*)
from page pa
where pa.page_namespace = 0 and... |
3 years ago |
use enwiki_p;
select count(*)
from page pa
where pa.page_namespace = 0 and... |
3 years ago |
use enwiki_p;
select *
from page pa
where pa.page_namespace = 0 and... |
3 years ago |
use enwiki_p;
select *
from page pa
where pa.page_namespace = 0 and... |
3 years ago |
use hrwiki_p;
select * from page
where page_namespace=118 |
3 years ago |