| select * from page where page_id = 356457 limit 10; |
2 years ago |
| select * from page where page_title = 356457 limit 10; |
2 years ago |
| select * from page where page_title = "Lookup_table" limit 10; |
2 years ago |
| select * from page where page_id = "356457" limit 10; |
2 years ago |
| select * from page where page_title = "lookup_table" limit 10; |
2 years ago |
| select page_namespace from page where page_title = "lookup_table"; |
2 years ago |
| select page_namespace from page where page_name = "lookup_table"; |
2 years ago |
|
select page_id from page where page_title = "heartbeat_protocol" limit 10; |
2 years ago |
| select page_is_redirect from page where page_title = "heartbeat_protocol" limit 10; |
2 years ago |
| select page_is_redirect from page where page_id = "356457" limit 10; |
2 years ago |
| select page_counter from page where page_id = "356457" limit 10; |
2 years ago |
| select page_id from page where page_title = "Lookup_table" limit 10; |
2 years ago |
| select page_restrictions from page where page_title = "Lookup_table" limit 10; |
2 years ago |
| select page_id from page where page_title = "Lookup_table" limit 10; |
2 years ago |
| select page_id from page where page_title = "MIT" limit 10; |
2 years ago |
| select page_id from page where page_title = "MIT"; |
2 years ago |
| select * from revision_userindex
where actor_name = "WikiLinuz" limit 10; |
2 years ago |
| select * from revision_userindex
where rev_actor = (select user_id from... |
2 years ago |
| select user_id from user where user_name = "WikiLinuz" |
2 years ago |
| select rev_comment_id from revision_userindex
where rev_actor = (select... |
2 years ago |
| select rev_comment from revision_userindex
where rev_actor = (select... |
2 years ago |
| select rev_page from revision_userindex
where rev_actor = (select user_id... |
2 years ago |
| select rev_page from revision_userindex
where rev_actor = (select user_id... |
2 years ago |
| describe revision_userindex; |
2 years ago |
| select actor_id from actor_revision where actor_name = "WikiLinuz"; |
2 years ago |
| describe actor_revision; |
2 years ago |
| describe revision_userindex; |
2 years ago |
| select * from revision_userindex where
rev_actor = (select actor_id from... |
2 years ago |
| select actor_id from actor where actor_name = "WikiLinuz"; |
2 years ago |
| select page_latest from page limit 10; |
2 years ago |
| select * from revision where rev_id = "42144160" limit 10; |
2 years ago |
| describe revision; |
2 years ago |
| select rev_comment from revision where rev_user = "42144160" limit 10; |
2 years ago |
| select user_id from user where user_name = "WikiLinuz"; |
2 years ago |
| describe revision; |
2 years ago |
| describe revision_userindex; |
2 years ago |
| show tables from enwiki_p; |
2 years ago |
| select * from actor where actor_name = "WikiLinuz"; |
2 years ago |
| select * from actor limit 10; |
2 years ago |
| select * from content limit 10; |
2 years ago |
| describe comment; |
2 years ago |
| select actor_name from actor limit 10; |
2 years ago |
| select actor_name from actor_table limit 10; |
2 years ago |
| select user_name from user limit 10; |
2 years ago |
| select user_email from user limit 10; |
2 years ago |
| select user_email from user; |
2 years ago |
| select user_email from "user"; |
2 years ago |
| select user_email from "user" where |
2 years ago |
| select user_email from user where user_name = "WikiLinuz" |
2 years ago |
