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