| use wikidatawiki_p;
select *#pl_title
from pagelinks
where pl_title in... |
9 years ago |
| use wikidatawiki_p;
select *#pl_title
from pagelinks
where pl_title in... |
9 years ago |
| /*use wikidatawiki_p;
select *#pl_title
from pagelinks
where pl_title in... |
9 years ago |
| use wikidatawiki_p;
select *#pl_title
from pagelinks
where... |
9 years ago |
| use wikidatawiki_p;
select *#pl_title
from pagelinks
where pl_from=19033469
limit 15; |
9 years ago |
| use wikidatawiki_p;
select *#pl_title
from pagelinks
where pl_from=19033469
limit 15; |
9 years ago |
| use lvwiki_p;
select pl_title#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use lvwiki_p;
select pl_title#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| USE enwiki_p;
select tl.tl_title, count(tl.tl_from) from templatelinks... |
9 years ago |
| USE enwiki_p;
select tl.tl_title, count(tl.tl_from) from templatelinks... |
9 years ago |
| USE enwiki_p;
select tl.tl_title, count(tl.tl_from) from templatelinks... |
9 years ago |
| use enwiki_p;
select concat('*... |
9 years ago |
| use enwiki_p;
select concat('*... |
9 years ago |
| use enwiki_p;
select concat('*... |
9 years ago |
| use enwiki_p;
select concat('*... |
9 years ago |
| USE enwiki_p;
select count(tl.tl_from) from templatelinks tl
where... |
9 years ago |
| use lvwiki_p;
select pl_title#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use lvwiki_p;
select pl_title#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use lvwiki_p;
select *#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use lvwiki_p;
select *#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use lvwiki_p;
select *#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use lvwiki_p;
select *#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use lvwiki_p;
select *#pl.pl_title, COUNT(pl.pl_title)
from pagelinks... |
9 years ago |
| use enwiki_p;
select concat('*... |
9 years ago |
| use enwiki_p;
select concat('*... |
9 years ago |
| use plwiki_p;
select concat('* [[',REPLACE(l.ll_title, '_', ' '),']]')
from... |
9 years ago |
| use plwiki_p;
select concat('* [[',REPLACE(l.ll_title, '_', ' '),']]')
from... |
9 years ago |
| use enwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join... |
9 years ago |
| use enwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join... |
9 years ago |
| use enwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join... |
9 years ago |
| use ruwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join... |
9 years ago |
| use ruwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join... |
9 years ago |
| use ruwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join... |
9 years ago |
| use ruwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join... |
9 years ago |
