use itwiki_p;
select page_title, page_id, count(*) from page
join imagelinks... |
3 years ago |
use vecwiki_p;
select page_title, page_id, count(*) from page
join... |
3 years ago |
use vecwiki_p;
select page_title, page_id, count(*) from page
join... |
3 years ago |
use vecwiki_p;
select page_title, page_id, count(*) from page
join... |
3 years ago |
use vecwiki_p;
select page_title, page_id, count(*) from page
join... |
3 years ago |
use vecwiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN... |
3 years ago |
use vecwiki_p;
select page_title, page_id, count(*) from page
join... |
3 years ago |
use afwiki_p;
select page_title, page_id, count(*) from page
join imagelinks... |
3 years ago |
use afwiki_p;
select * from page
join imagelinks on page_id = il_from
where... |
3 years ago |
use afwiki_p;
select * from page
join pagelinks on page_id = il_from
where... |
3 years ago |
use afwiki_p;
select page_title from page
where page_id = 41 and page_namespace = 0 |
3 years ago |