| SELECT pp_value FROM page, page AS page2, page_props, pagelinks
WHERE... |
7 years ago |
| SELECT pp_value FROM page, page AS page2, page_props, pagelinks
WHERE... |
7 years ago |
| SELECT pp_value FROM page, page AS page2, page_props, pagelinks
WHERE... |
7 years ago |
| SELECT pp_value FROM page, page AS page2, pageprops, pagelinks
WHERE... |
7 years ago |
| SELECT * FROM page_props WHERE pp_propname = "wikibase_item" LIMIT 10; |
7 years ago |
| SELECT * FROM page_props WHERE pp_propname = wikibase_item LIMIT 10; |
7 years ago |
| SELECT * FROM page_props WHERE pp_page = 12; |
7 years ago |
| DESCRIBE page_props; |
7 years ago |
| SELECT * FROM langlinks WHERE ll_from = 12; |
7 years ago |
| SELECT * FROM langlinks WHWRE ll_from = 12; |
7 years ago |
| DESCRIBE langlinks |
7 years ago |
| SHOW tables; |
7 years ago |
| SELECT page_title, iwl_title FROM page, iwlinks WHERE page_title = "Author"... |
7 years ago |
| SELECT page_title, iwl_title FROM page, iwlinks WHERE page_id = iwl_from AND... |
7 years ago |
| SELECT * FROM iwlinks WHERE iwl_prefix = "d" LIMIT 10; |
7 years ago |
| SELECT * FROM iwlinks WHERE iwl_prefix = "d"; |
7 years ago |
| SELECT * FROM iwlinks WHERE iwl_from = 12; |
7 years ago |
| DESCRIBE iwlinks; |
7 years ago |
| SHOW tables; |
7 years ago |
| SELECT * FROM interwiki LIMIT 10; |
7 years ago |
| SELECT * FROM pagelinks WHERE pl_from = 12; |
7 years ago |
| SELECT * FROM pagelink WHERE pl_from = 12; |
7 years ago |
| SELECT * FROM interwiki WHERE iwl_from = 12; |
7 years ago |
| describe pagelinks; |
7 years ago |
| describe interwiki; |
7 years ago |
| describe interwikilink; |
7 years ago |
| describe interwikilinks; |
7 years ago |
| describe page; |
7 years ago |
| show columns FROM page; |
7 years ago |
| show tables FROM enwiki_p; |
7 years ago |
| show tables FROM enwiki; |
7 years ago |
| show tables FROM wikidatawiki; |
7 years ago |
| show tables wikidatawiki; |
7 years ago |
| show databases; |
7 years ago |
