Query Run
use knwiki_p; Select * from page where page_namespace = 1 and... 11 months ago
use tcywiki_p; Select Count(*) from page where page_namespace = 0 and... 2 years ago
use knwiki_p; Select Count(*) from page where page_namespace = 0 and... 6 years ago
use knwiki_p; select count(*) from user where user_editcount > 5; Select... 6 years ago
use knwiki_p; select count(*) from user where user_editcount > 5; Select... 7 years ago
use knwiki_p; select count(*) from user where user_editcount > 5; 7 years ago
use knwiki_p; select count(*) from user where user_editcount > 0; 7 years ago
use knwiki_p; select count(*) from user where user_editcount > 5; 7 years ago
use knwiki_p; select page_title, page_len from page where page_len < '6144'... 7 years ago
use knwiki_p; select page_title, page_len from page where page_len < '6144'... 8 years ago
use knwiki_p; select page_title, page_len from page where page_len < '6144'... 8 years ago
use knwiki_p; select page_title, page_len from page where page_len < '6144'... 8 years ago
use knwiki_p; select page_title, page_len from page where page_len < '6144'... 8 years ago
use knwiki_p; select page_title from page, page_len where page_len < '6144'... 8 years ago
use knwiki_p; show tables; desc page; 8 years ago
use knwiki_p; select page_title from page where page_len < '6144' and... 8 years ago
use knwiki_p; show tables; 8 years ago
show databases; 8 years ago
use knwiki_p; SELECT log_title, COUNT(*) FROM logging WHERE... 8 years ago
use knwiki_p; SELECT log_title, COUNT(*) FROM logging WHERE... 8 years ago
use knwiki_p; SELECT LEFT(log_timestamp, 6) as month, COUNT(*) FROM logging... 8 years ago
use knwiki_p; SELECT page_namespace, page_title, page_len FROM... 8 years ago
use knwiki_p; show tables; desc user; desc page; desc revision; 8 years ago
use knwiki_p; select count(*) from page where page_title like "ಪ%" and... 8 years ago
use knwiki_p; show tables; desc user; desc page; 8 years ago
use knwiki_p; show tables; desc user; 8 years ago
use knwiki_p; select count(*) from page, revision where rev_page = page_id... 8 years ago
use knwiki_p; show tables; desc revision; 8 years ago
use knwiki_p; select * from user where user_name ="Pavanaja"; 8 years ago
use knwiki_p; show tables; desc user; DESCRIBE user_properties; 8 years ago
use knwiki_p; show tables; DESCRIBE user_properties; 8 years ago
use knwiki_p; show tables; DESCRIBE knwiki_p.page; 8 years ago
use knwiki_p; show tables; 8 years ago
use knwiki_p; desc pages; 8 years ago
use knwiki_p; select * from page where page_title like "ಅ%" limit 10; 8 years ago
use knwiki_p; select * from page where page_title like "ಅ%" limit =10; 8 years ago
use knwiki_p; show tables; desc page; 8 years ago
use knwiki_p; show tables; 8 years ago
use knwiki_p; select page_title from page where page_title like "'%"; 8 years ago
use knwiki_p; select page_title from page where page_title like "'%"; 8 years ago
use knwiki_p; select page_title from page where page_title < "z"; 8 years ago
use knwiki_p; show tables; select page_title from page where page_title like "ಪ%"; 8 years ago
use knwiki_p; show tables; select * from page_title where page_title like "ಪ%"; 8 years ago
use knwiki_p; show tables; select * from page_title where page_title like "ಪ%"; 8 years ago
use knwiki_p; show tables; select * from page_title where page_title like "ಪ%"; 8 years ago
use knwiki_p; show tables; select * from page_title where page_title like "ಪ%"; 8 years ago
use knwiki_p; show tables; desc page; 8 years ago
use knwiki_p; show tables; 8 years ago
use knwiki_p; select * from user where user_name Like "ಪ%"; 8 years ago
use knwiki_p; select page_title where page_title like "ಪ%"; 8 years ago
use knwiki_p; Select Count(*) from page where page_namespace = 0 and... 8 years ago
use knwiki_p; Select Count(*) from page where page_namespace = 0 and... 8 years ago
use orwiki; Select Count(*) from page where page_namespace = 0 and... 8 years ago
use knwiki; Select Count(*) from page where page_namespace = 0 and... 8 years ago
use knwiki; show tables; Select Count(*) from page where page_namespace = 0... 8 years ago
use knwiki; show tables; Select Count(*) from page where page_namespace = 0... 8 years ago
use knwiki; show tables; 8 years ago
use knwiki; show tables; desc page; 8 years ago
use knwiki; show tables; Select Count(*) from page where page_namespace = 0; 8 years ago
use knwiki; show tables; select * from page; 8 years ago
use knwiki; show tables; desc page; 8 years ago
use knwiki; show tables; 8 years ago
use knwiki; show tables; desc user_properties; 8 years ago
use knwiki; show tables; 8 years ago
use knwiki; select * from user_properties; 8 years ago
use knwiki; select * from user_properties; 8 years ago
use knwiki; show columns from user_properties; 8 years ago
use knwiki; show tables; 8 years ago