Query Run
#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