use enwiki_p;
select
CONCAT('Category:', cl_to) as category_name,
... |
3 years ago |
use enwiki_p;
select
cl_to as category_name,
count(*) as... |
3 years ago |
use enwiki_p;
select
cl_to as category_name,
count(*) as... |
3 years ago |
use enwiki_p;
select
cl_to as category_name,
count(*) as... |
3 years ago |
use enwiki_p;
select
cl_to as category_name,
count(*) as... |
3 years ago |
use enwiki_p;
select
cl_to as category_name,
count(*) as... |
3 years ago |
use enwiki_p;
select
cl_to as category_name,
count(*) as... |
3 years ago |
use enwiki_p;
select
cl_to as category_name,
count(*) as... |
3 years ago |
use enwiki_p;
select page_title, cl_to
from categorylinks
join page
on... |
3 years ago |
use enwiki_p;
select page_title, cl_to
from categorylinks
join page
on... |
3 years ago |
use enwiki_p;
select page_title
from categorylinks
join page
on page_id =... |
3 years ago |
use enwiki_p;
select cl_from
from categorylinks
where cl_to = 'Taxa_by_author'
; |
3 years ago |
use enwiki_p;
select cl_from
from categorylinks
where cl_to =... |
3 years ago |
use enwiki_p;
select cl_from
from categorylinks
where cl_to = 'Taxa by... |
3 years ago |