| select subpage.page_title from page_restrictions source join page basepage... |
5 years ago |
| select distinct concat("* [[Module:",page_title,"]]") from... |
5 years ago |
| select distinct concat("[[Module:",page_title,"]]") from revision_userindex... |
5 years ago |
| select distinct page_namespace, page_title from revision_userindex
join... |
5 years ago |
| select page_namespace, page_title from revision_userindex
join... |
5 years ago |
| select * from revision_userindex
join page_restrictions on pr_page =... |
5 years ago |
| select * from revision_userindex where rev_user_text = "Pppery"; |
5 years ago |
| select * from revision where rev_user_text = "Pppery"; |
5 years ago |
| select * from user limit 20; |
5 years ago |
| select rev_page from revision_userindex where rev_user_text ="Pppery" |
5 years ago |
| select rev_page from revision_userindex where rev_user_text ="Pppery" |
5 years ago |
| select rev_page from revision_userindex where user_text ="Pppery" |
5 years ago |
| select rev_page from revision_userindex where rev_id="Pppery" |
5 years ago |
| SELECT distinct rev_page from revision where rev_user_text = "Pppery" |
5 years ago |
| SELECT * from archive_userindex where ar_user_text = "Pppery" and... |
5 years ago |
| SELECT * from archive_userindex where ar_user_text = "Pppery" and ar_namespace = 10; |
5 years ago |
| SELECT * from archive_userindex where ar_user_text = "Pppery" |
5 years ago |
| SELECT * from archive where ar_user_text = "Pppery" |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| page_title, count(tl_from) from page
join templatelinks on tl_namespace =... |
5 years ago |
| select 1 |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from)
join templatelinks on tl_namespace =... |
5 years ago |
| select page_title, count(select 1 from templatelinks where tl_namespace =... |
5 years ago |
| select * from page
where page_namespace = 10 and page_title like "PDB_G%/%"; |
5 years ago |
| select * from page
where page_namespace = 10 and page_title like "PDB G%/%"; |
5 years ago |
| select * from page
join templatelinks on tl_namespace = page_namespace and... |
5 years ago |
| select * from page
join templatelinks on tl_namespace = page_namespace and... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select page_title, count(tl_from) from page
join templatelinks on... |
5 years ago |
| select * from page
where page_namespace = 10 and page_title like "PDB%/%"... |
5 years ago |
| select * from page
where page_namespace = 10 and page_title like "PBB%/%"... |
5 years ago |
| select * from page
where page_namespace = 10 and page_title like "PBB%/" |
5 years ago |
| select * from page join templatelinks on tl_namespace = page_namespace and... |
5 years ago |
| select * from templatelinks where tl_namespace = 0 and tl_title like "PBB%/%"; |
5 years ago |
| select * from templatelinks where tl_namespace = 10 and tl_title like "PBB%/%"; |
5 years ago |
| select * from templatelinks where tl_namespace = 10 and tl_title like "PBB%" limit 1; |
5 years ago |
| select * from templatelinks where tl_namespace = 10 and tl_title like "PBB%" limit 1; |
5 years ago |
| select * from templatelinks where tl_title like "PBB%" limit 1; |
5 years ago |
| select 1; |
5 years ago |
| select * from templatelinks where tl_title like "PBB%" limit 1; |
5 years ago |
| select * from templatelinks where tl_title like "PBB%" |
5 years ago |
| select * from categorylinks join page on cl_from = page_id join... |
5 years ago |
| select * from categorylinks join page on cl_from = page_id join... |
5 years ago |
| select * from categorylinks join page on cl_from = page_id join... |
5 years ago |
| select * from categorylinks where cl_to = "Wikipedia_substituted_templates" |
5 years ago |
| select * from catlinks where cl_to = "Wikipedia_substituted_templates" |
5 years ago |
| select distinct concat("Module:",replace(ar_title,"_"," ")) from... |
5 years ago |
| select distinct concat("Module:",replace(ar_title,"_"," ")) from... |
5 years ago |
| select * from archive where ar_namespace = 828 limit 100; |
5 years ago |
| select * from archive where ar_namespace == 828 limit 100; |
5 years ago |
| select * from archive_userindex limit 1; |
5 years ago |
| kill |
5 years ago |
| select ar_title from archive where ar_user_text = "Pppery"; |
5 years ago |
| select * from archive limit 1; |
5 years ago |
