use metawiki_p;
select count(*) from iwlinks
where... |
4 years ago |
use metawiki_p;
select count(*) from iwlinks
where iwl_prefix='wikidata'; |
4 years ago |
use wikidata_p;
select count(*) from page; |
4 years ago |
use metawiki_p;
select * from page where page_id=10709084;
select * from... |
4 years ago |
use metawiki_p;
select * from page where page_id=10709084;
select * from... |
4 years ago |
use metawiki_p;
select * from page where page_id=10709084;
select * from... |
4 years ago |
use metawiki_p;
select * from page where... |
4 years ago |
use metawiki_p;
select max(page_title) from page
where page_title like... |
4 years ago |
use metawiki_p;
select max(page_title) from page
where page_title like... |
4 years ago |
use metawiki_p;
select max(page_title) from page
where page_namespace=0;
|
4 years ago |
use metawiki_p;
select * from page
where page_title like '%Armstrong%'
and... |
4 years ago |
use wikidata_p;
select * from page
where page_title like '%Q1779%'
and... |
4 years ago |
use datawiki_p;
select * from page
where page_title like '%Q1779%'
and... |
4 years ago |
use metawiki_p;
select * from page
where page_title like '%Q1779%'
and... |
4 years ago |
use metawiki_p;
select * from page
where page_title like '%Q1234%';
|
4 years ago |
use metawiki_p;
select * from page
where page_title = 'Q1';
|
4 years ago |
use metawiki_p;
show tables;
|
4 years ago |
use metawiki_p;
show tables;
show table langlinks; |
4 years ago |
use metawiki_p;
show tables;
select * from metawiki_p.langlinks; |
4 years ago |
use metawiki_p;
show tables;
|
4 years ago |
select * from metawiki_p.tables;
|
4 years ago |
select tables from metawiki_p.interwiki
|
4 years ago |
select distinct iw_prefix from metawiki_p.interwiki;
select count(*) from... |
4 years ago |
select count(*) from metawiki_p.page;
select count(*) from... |
4 years ago |
select count(*) from metawiki_p.page; |
4 years ago |