use afwiki_p;
select count(count(distinct(il_to))) from page
join imagelinks... |
4 years ago |
use afwiki_p;
select count(count(*)) from page
join imagelinks on page_id =... |
4 years ago |
use afwiki_p;
select page_id, count(*) from page
join imagelinks on page_id... |
4 years ago |
use afwiki_p;
select count(distinct(page_id)) from page
join imagelinks on... |
4 years ago |
use afwiki_p;
select count(distinct(page_id)) from page
#join imagelinks on... |
4 years ago |
use afwiki_p;
select * from page
join imagelinks on page_id = il_from and... |
4 years ago |
use rowiki_p;
select * from page
join imagelinks on page_id = il_from and... |
4 years ago |
use rowiki_p;
select * from page
join imagelinks on page_id = il_from and... |
4 years ago |
use itwiki_p;
select * from page
join imagelinks on page_id = il_from and... |
4 years ago |
use itwiki_p;
select * from page
join imagelinks on page_id = il_from
where... |
4 years ago |
use afwiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page... |
4 years ago |
use itwiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page... |
4 years ago |
use itwiki_p;
select count(distinct(page_id)) from page
where page_namespace = 0 |
4 years ago |
#use afwiki_p;
select count(distinct(page_id)) from page |
4 years ago |
use afwiki_p;
select count(distinct(page_id)) from page |
4 years ago |
use afwiki_p;
select count distinct page_id from page |
4 years ago |
use wikidatawiki_p;
show tables |
4 years ago |