| use knwikisource_p;
SELECT sum(page_len)
FROM page WHERE page_namespace = 104; |
8 years ago |
| use knwiki_p;
SELECT sum(page_len)
FROM page WHERE page_namespace = 0
AND... |
8 years ago |
| use knwiki_p;
SELECT count(distinct(page_id))
FROM page WHERE page_namespace... |
8 years ago |
| use knwiki_p;
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page... |
8 years ago |
| use knwiki_p;
#select * from page where page_namespace=0 order by page_id... |
8 years ago |
| use knwiki_p;
#select * from page where page_namespace=0 order by page_id... |
8 years ago |
| use knwiki_p;
#select * from page where page_namespace=0 order by page_id... |
8 years ago |
| use knwiki_p;
#select * from page where page_namespace=0 order by page_id... |
8 years ago |
| use knwiki_p;
#select * from page where page_namespace=0 order by page_id... |
8 years ago |
| use knwiki_p;
select * from page where page_namespace=0 order by page_id limit 10; |
8 years ago |
| use knwiki_p;
select * from page where page_namespace=0 limit 10; |
8 years ago |
| use knwiki_p;
select * from page where 1 limit 10; |
8 years ago |
| use knwiki_p;
select * from revision where 1 limit 10; |
8 years ago |
| use knwiki_p;
select * from revision where 1 limit 2; |
8 years ago |
| use knwiki_p;
select * from revision where 1 limit 1; |
8 years ago |
