| select * from page_props where pp_page in (select page_id from page where... |
4 years ago |
| select * from page_props where pp_page in (select * from page where... |
4 years ago |
| describe page_props; |
4 years ago |
| select * from content limit 3; |
4 years ago |
| select * from content where content_id in (select page_id from page where... |
4 years ago |
| select * from content where content_id in (select page_id where... |
4 years ago |
| describe content; |
4 years ago |
| select * from page where page_title="Hedy_Lamarr"; |
4 years ago |
| select * from page where page_title="Hedy Lamarr"; |
4 years ago |
| select page_content_model from page where page_title="Hedy Lamarr"; |
4 years ago |
| select * from nlwiki_p.category where cat_title="In Popular culture" limit 10;
|
4 years ago |
| DESCRIBE nlwiki_p.category;
|
4 years ago |
| describe table category;
|
4 years ago |
| SHOW TABLES FROM enwiki_p;
|
4 years ago |
| select * from page where page_title="Hedy_Lamarr"; |
4 years ago |
| select pl_title, pl_namespace from pagelinks where pl_from in (select... |
4 years ago |
| select page.page_id, page.page_title from pagelinks, page where... |
4 years ago |
| select page.page_id, page.page_title from pagelinks, page where... |
4 years ago |
| select page.page_id, page.page_title from pagelinks, page where... |
4 years ago |
| select pl_title, pl_namespace from pagelinks where pl_from in (select... |
4 years ago |
| select * from page where page_title="February_11"; |
4 years ago |
| select page_id from page where page_title="February_11"; |
4 years ago |
