#evidence that page_id is unique in table page
USE cswiki_p;
select... |
5 years ago |
USE cswiki_p;
select count(*), page_title, page_id from page where page_id >... |
5 years ago |
USE cswiki_p;
select count(*), page_title, page_id from page where page_id >... |
5 years ago |
USE cswiki_p;
select count(*), page_title, page_id from page where page_id >... |
5 years ago |
USE cswiki_p;
select count(*), page_id from page where page_id > 1476161
... |
5 years ago |
USE cswiki_p;
select count(*) from page where page_id > 1476161
GROUP BY ... |
5 years ago |
USE cswiki_p;
select * from page where page_id > 1476161
GROUP BY ... |
5 years ago |
USE cswiki_p;
select * from page where page_id > 1476140
GROUP BY ... |
5 years ago |
USE cswiki_p;
select * from page where page_id > 1476140
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from page where page_id > 1476100
LIMIT 200;
|
5 years ago |
USE cswiki_p;
select count(*), * from page where page_id > 1476100
LIMIT 200;
|
5 years ago |
USE cswiki_p;
select count(*), page_id, page_title from page where page_id >... |
5 years ago |
USE cswiki_p;
select page_id, page_title from page where page_id >... |
5 years ago |
USE cswiki_p;
select page_id, page_title from page where page_id >... |
5 years ago |
USE cswiki_p;
select page_id, page_title from page where page_id >... |
5 years ago |
USE cswiki_p;
select count(*), page_title from page where page_id >... |
5 years ago |
USE cswiki_p;
select count(*), page_title from page where page_id >... |
5 years ago |
USE cswiki_p;
select count(*), page_title from page where page_id >... |
5 years ago |
USE cswiki_p;
select count(*), page_title from page where page_id > 1439900
... |
5 years ago |
USE cswiki_p;
select count(*) from page where page_id > 1172161
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select count(*) from page
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select count(*) from page where page_id < 11
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from page where page_id < 11
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from page_props where pp_page < 11
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from page_props where pp_page < 11
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from page_props where pp_page < 10
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from page_props where pp_page = 10
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from page_props
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from langlinks where ll_from = 468074
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from langlinks where ll_from = 4
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from langlinks
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from langlinks where ll_lang = 'en'
LIMIT 20;
|
5 years ago |
USE cswiki_p;
select * from langlinks where ll_from = page_id and ll_lang =... |
5 years ago |