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 |