select u.page_id as user_id, t.page_id as usertalk_id, u.page_title from... |
6 years ago |
select u.page_id as user_id, t.page_id as usertalk_id, u.page_title from... |
6 years ago |
select u.page_id as user_pageid, t.page_id as usertalk_pageid from page u... |
6 years ago |
select u.page_id as user_pageid from page u inner join select t.page_id as... |
6 years ago |
select u.page_id as user_pageid from page u where u.page_namespace = 2 inner... |
6 years ago |
select u.page_id as user_pageid from page u where u.page_namespace = 2 join... |
6 years ago |
select page_id as user_pageid from page u where u.page_namespace = 2 join... |
6 years ago |
select page_id as user_pageid from page u where u.page_namespace = 2 inner... |
6 years ago |
select page_id as user_pageid from page u where u.page_namespace = 2 inner... |
6 years ago |
select page_id as user_pageid from page u where page_namespace = 2 inner... |
6 years ago |
select page_id, page_title from page where page_namespace = 2 union select... |
6 years ago |
select page_id, page_title from page where page_namespace = 2 union page_id,... |
6 years ago |
select page_id, page_title from page where page_namespace = 2 and page_title... |
6 years ago |
select page_id, page_title from page where page_namespace = 3 and page_title... |
6 years ago |
select page_id, page_title from page where page_namespace = 2 and page_title... |
6 years ago |
select page_id, page_title from page where page_namespace = 2 and title = 'Drmies'; |
6 years ago |
select page_id, page_title from page where page_namespace = 2 limit 10;
|
6 years ago |
select page_id, page_title from page where page_namespace = 2 or 3 and... |
6 years ago |
select page_title from page where page_namespace = 2 or 3 and page_title =... |
6 years ago |
select distinct page_namespace from page;
|
6 years ago |
select distinct page_namespace from page where page_namespace = "User talk"... |
6 years ago |
select distinct page_namespace from page where page_namespace = "User talk"... |
6 years ago |
select page_title, page_namespace from page where page_namespace = "User... |
6 years ago |
select * from protected_titles limit 10;
|
6 years ago |
show create table protected_titles;
|
6 years ago |
show create table content;
|
6 years ago |
show tables;
|
6 years ago |
show create table user;
|
6 years ago |
show tables;
|
6 years ago |
show create table page;
|
6 years ago |
show create table page\G;
|
6 years ago |
show tables;
|
6 years ago |