use enwiki_p;
select concat("# [[:en:", pa.page_title, "|", pa.page_title,... |
3 years ago |
use enwiki_p;
select concat("# [[:en:", pa.page_title, "|]]") as wl,... |
3 years ago |
use enwiki_p;
select "[[:en:" || pa.page_title || "|]]", count(*) as n
from... |
3 years ago |
use enwiki_p;
select pa.page_title, count(*) as n
from page pa
inner join... |
3 years ago |
use enwiki_p;
select pa.page_title, count(*) as n
from page pa
inner join... |
3 years ago |
use enwiki_p;
select pa.page_title, count(*) as n
from page pa
inner join... |
3 years ago |
use enwiki_p;
select pa.page_title, count(*) as n
from page pa
inner join... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*) as n
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*)
from page... |
3 years ago |
use enwiki_p;
select pa.page_id, pa.page_title, count(*)
from page... |
3 years ago |
use enwiki_p;
select *
from page pa
inner join langlinks ll on ll.ll_from... |
3 years ago |
use enwiki_p;
select *
from page pa
inner join langlinks ll on ll.ll_from... |
3 years ago |
use enwiki_p;
select *
from page pa
#inner join langlinks ll on ll.ll_from... |
3 years ago |
use enwiki_p;
select *
from page p
#inner join langlinks ll on ll.ll_from... |
3 years ago |
use enwiki_p;
select * from langlinks
limit 20; |
3 years ago |
use enwiki_p;
select * from redirect
where rd_interwiki = "hr"
limit 20; |
3 years ago |
use enwiki_p;
select * from redirect
where length(rd_interwiki) <> 0
limit 20; |
3 years ago |
use enwiki_p;
select * from redirect
where length(rd_interwiki) = 0
limit 20; |
3 years ago |
use enwiki_p;
select * from redirect
where rd_interwiki is not null
limit 20; |
3 years ago |
use enwiki_p;
select * from redirect
where rd_interwiki is not null
limit 20; |
3 years ago |
use enwiki_p;
select * from redirect
limit 20; |
3 years ago |
use enwiki_p;
select * from interwiki
limit 20; |
3 years ago |