| # Adapted from "replicating Xtools stuff in a normal query", 29 Dec... |
2 months ago |
| # Adapted from "replicating Xtools stuff in a normal query", 29 Dec... |
2 months ago |
| select * from page where page_title like "Broken/%" |
2 months ago |
| select * from page where page_title like "Broken%" |
2 months ago |
| select * from page where page_title like "MOS:%" |
2 months ago |
| select * from page where page_namespace=1198 and page_title not like "%/en"... |
2 months ago |
| select * from page where page_namespace=1198 and page_title not like "%/en"... |
2 months ago |
| select * from page where page_namespace=1198 and page_title not like "%/en"... |
2 months ago |
| select * from page where page_namespace=1198 and page_title not like "%/en"... |
2 months ago |
| select * from page where page_namespace=1198 and not exists (select 1 from... |
2 months ago |
| select * from page where page_namespace=1198 and not exists (select 1 from... |
2 months ago |
| select * from revtag where rt_page=2019628; |
2 months ago |
| select * from revtag where rt_page=2019628; |
2 months ago |
| select * from translate_metadata where tmd_key != "prioritylangs" and... |
2 months ago |
| select * from translate_metadata where tmd_key != "prioritylangs" and... |
2 months ago |
| select * from translate_metadata where tmd_key != "prioritylangs" limit 1000; |
2 months ago |
| select * from translate_metadata limit 1000; |
2 months ago |
| select * from translate_metadata limit 10; |
2 months ago |
| select * from archive where ar_rev_id=1601816; |
3 months ago |
| select * from wiki; |
3 months ago |
| select * from templatelinks join linktarget on lt_id=tl_target_id where... |
4 months ago |
| select * from langlinks where ll_from=(select page_id from page where... |
4 months ago |
| select * from langlinks where ll_from=960 |
4 months ago |
| select * from langlinks where ll_from=5043 |
4 months ago |
| select * from langlinks where ll_from=2943 |
4 months ago |
| select * from langlinks where ll_from=8229 |
4 months ago |
| select b.ips_site_id,a.ips_site_page from wb_items_per_site a join... |
4 months ago |
| select b.ips_site_id, b.ips_site_page,a.ips_site_page from wb_items_per_site... |
4 months ago |
| select count(*) from langlinks; |
4 months ago |
| select b.ips_site_id, b.ips_site_page from wb_items_per_site a join... |
4 months ago |
| select b.lps_site_id, b.ips_site_page from wb_items_per_site a join... |
4 months ago |
| select a.ips_site_id, b.ips_site_page from wb_items_per_site a join... |
4 months ago |
| select * from wb_items_per_site where ips_site_id="dtpwiki" limit 10; |
4 months ago |
| select * from wb_items_per_site limit 10; |
4 months ago |
| select * from langlinks; |
4 months ago |
| select * from langlinks; |
4 months ago |
| select ll_from,ll_title from langlinks group by ll_from having... |
4 months ago |
| select ll_from,ll_title from langlinks group by ll_from having... |
4 months ago |
| select * from langlinks order by ll_from limit 10000; |
4 months ago |
| select from langlinks order by ll_from limit 10000; |
4 months ago |
| select from langlinks order by il_from asc limit 10000; |
4 months ago |
| select * from langlinks limit 100; |
4 months ago |
| select * from langlinks limit 100; |
4 months ago |
| select * from langlinks; |
4 months ago |
| select * from revtag join page on rt_page=page_id and... |
4 months ago |
| select * from revtag join page on rt_page=page_id and... |
4 months ago |
| select * from revtag join page on rt_page=page_id and... |
4 months ago |
| select * from revtag join page on rt_page=page_id and... |
4 months ago |
| select * from revtag where rt_page=1981423; |
5 months ago |
| select * from revtag where rt_page=1981423; |
5 months ago |
| select * from revtag where rt_page=12460909; |
5 months ago |
| select * from revtag where rt_id=25800133; |
5 months ago |
| select * from revtag where rt_id=25800133; |
5 months ago |
| select a.page_title,b.page_title from page a
join page b on... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
5 months ago |
| select * from page where page_title like "%(%" and page_namespace < 200 and... |
6 months ago |
| select * from page where page_title like "%(%" and page_namespace < 200 and... |
6 months ago |
| select * from page where page_title like "%(%" and page_namespace < 200 and... |
6 months ago |
| select * from page where page_title like "%(%" and page_namespace < 200 and... |
6 months ago |
| select * from page where page_title like "%(%" and page_namespace < 200... |
6 months ago |
| select * from page where page_title like "%(%" and page_title < 200 order by... |
6 months ago |
| blank query |
7 months ago |
| WITH dabs_and_redirects AS (
WITH dabs AS (
SELECT page_title AS dab
... |
7 months ago |
| WITH dabs_and_redirects AS (
WITH dabs AS (
SELECT page_title AS dab
... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| SET @pat='(?i).*(?!<New_)century.*financ.*';
SELECT CONCAT('[[', CASE... |
7 months ago |
| SET @pat='(?i).*(?!<New)century.*financ.*';
SELECT CONCAT('[[', CASE... |
7 months ago |
| SET @pat='(?i).*(?!<New)century.*financ.*';
SELECT CONCAT('[[', CASE... |
7 months ago |
| SET @pat='(?i).*(?!<New)century.*financ.*';
SELECT CONCAT('[[', CASE... |
7 months ago |
| SET @pat='(?i).*century.*financ.*';
SELECT CONCAT('[[', CASE... |
7 months ago |
| SET @pat='(?i).*century.*financ';
SELECT CONCAT('[[', CASE page_namespace
... |
7 months ago |
| select regexp_escape("a") |
7 months ago |
| select regexp_escape("a") |
7 months ago |
| select rescape("a") |
7 months ago |
| select rescape("a") |
7 months ago |
| select * from page where page_namespace=0 and page_title rlike... |
7 months ago |
| select * from page where page_title rlike "(?i)\b(eat(s|ing)?|ate)\b.*\bshit\b" |
7 months ago |
| select * from page where page_title rlike "(?i)\b(eat(s|ing)?|ate)\b.*\bshit\b" |
7 months ago |
| select * from page where page_title like "%eat%shit%" |
7 months ago |
| select "!Gã!ne" RLIKE... |
7 months ago |
| select page_title from page where page_namespace=0 and page_title RLIKE... |
7 months ago |
| select "!Gã!ne" rlike... |
7 months ago |
| select "!Gã!ne" rlike... |
7 months ago |
| select "!Gã!ne" rlike "(?i)[ℂ℃℄ɕƌʥℇ℈℉ℊℋℌℍℎℏℐ‼ℑℒℕ℗℘ℙℚℛℜℝ℞℟℣ℤℨ℩ℬℭ℮ℯℰℱℲℳℴℹ℺⅁⅂⅃⅄ⅅⅆⅇⅈⅉⅎ]" |
7 months ago |
| select * from page where page_namespace=0 and page_title rlike "(?i)ℂ.*"; |
7 months ago |
| select * from page where page_namespace=0 and page_title rlike "(?i)ℂ.*"; |
7 months ago |
| select * from page where page_namespace=0 and page_title rlike "(?i).*ℂ.*"; |
7 months ago |
| select * from page where page_namespace=0 and page_title like "%ℂ%"; |
7 months ago |
| select * from protected_titles where pt_namespace=0 and pt_title like "A%"; |
7 months ago |
| select count(*) from protected_titles where pt_namespace=0 and pt_title like "A%"; |
7 months ago |
| select count(*) from protected_titles where pt_namespace=0 and pt_title like "A%"; |
7 months ago |
| select count(*) from protected_titles where pt_namespace=0; |
7 months ago |
| select count(*) from protected_titles where pt_namespace=0 and... |
7 months ago |
| select count(*) from protected_titles where pt_namespace=0; |
7 months ago |
| select * from page where page_namespace=0 and page_title like... |
7 months ago |
| select * from page where page_namespace=0 and page_title like... |
7 months ago |
| select * from protected_titles where pt_namespace=0 limit 10 |
7 months ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
7 months ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
7 months ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
7 months ago |
| SELECT art.page_title,
REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... |
8 months ago |
| SELECT art.page_title,
REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... |
8 months ago |
| blank query |
8 months ago |
| SELECT art.page_title,
REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... |
8 months ago |
| blank query |
8 months ago |
| SELECT art.page_title,
REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... |
8 months ago |
| SET @pat='(?i).*object.*show';
SELECT CONCAT('[[', CASE page_namespace
... |
8 months ago |
| SET @pat='(?i)(.*guest.*characters*)';
SELECT page_title,
EXISTS... |
8 months ago |
| SET @pat='(?i).*guest.*characters';
SELECT CONCAT('[[', CASE... |
8 months ago |
| select page_title from revision_userindex join page on rev_page=page_id... |
9 months ago |
| select * from revision_userindex where rev_actor=374 and rev_comment_id=10... |
9 months ago |
| select * from revision_userindex where rev_actor=374 and rev_comment_id=10... |
9 months ago |
| select * from revision_userindex where rev_actor=374 and rev_comment_id=10 limit 500; |
9 months ago |
| select * from revision_userindex where rev_actor=374 and rev_comment_id=10; |
9 months ago |
| select * from revision_userindex where rev_actor=374 and rev_comment=10; |
9 months ago |
| select * from revision_compat where rev_page=60136700 |
9 months ago |
| select * from revision where rev_page=60136700 |
9 months ago |
| select page_namespace,page_title,cl_timestamp from categorylinks join page... |
9 months ago |
| select page_namespace,page_title,cl_timestamp from categorylinks join page... |
9 months ago |
| select log_title as 'Page',
(select actor_name from actor_logging where... |
9 months ago |
| select log_title as 'Page',
(select actor_name from actor_logging where... |
9 months ago |
| select log_title as 'Page',
(select actor_name from actor_logging where... |
9 months ago |
| select comment_text from actor_archive join archive on ar_actor=actor_id... |
9 months ago |
| select comment_text from actor_archive join archive on ar_actor=actor_id... |
9 months ago |
| select comment_text from actor_archive join archive on ar_actor=actor_id... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| select... |
9 months ago |
| SET @cat = 'Proposed deletion as of 1 February 2024';
SELECT DISTINCT... |
9 months ago |
| SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... |
10 months ago |
| blank query |
10 months ago |
| SET @pat='(?i).*g.*marchand.*';
SELECT CONCAT('[[', CASE page_namespace
... |
10 months ago |
| SET @pat='(?i).*greg.*marchand.*';
SELECT CONCAT('[[', CASE page_namespace
... |
10 months ago |
| SET @pat='.*greg.*marchand.*';
SELECT CONCAT('[[', CASE page_namespace
... |
10 months ago |
| SET @pat='.*greg.*marchand.*';
SELECT CONCAT('[[', CASE page_namespace
... |
10 months ago |
| select page_namespace,page_title,cl_timestamp from categorylinks join page... |
10 months ago |
| SELECT CAST(MIN(rev_timestamp) AS DATETIME) AS '1st edit', page_title
FROM... |
10 months ago |
| SELECT CAST(MIN(rev_timestamp) AS DATETIME) AS '1st edit', page_title
FROM... |
10 months ago |
| select concat("Category:",page_title) from templatelinks join page on... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select... |
10 months ago |
| select user_name,user_editcount from user join user_groups on... |
10 months ago |
| select * from page right join category on cat_title=page_title where... |
11 months ago |
| select * from page where page_namespace=14 and exists (select 1 from... |
11 months ago |
| select * from page where page_namespace=14 and not exists (select 1 from... |
11 months ago |
| select * from page right join category on cat_title=page_title+"x" where... |
11 months ago |
| select * from page outer join category on cat_title=page_title+"x" where... |
11 months ago |
| select * from page outer join category on cat_title=page_title+"x" where... |
11 months ago |
| select * from page outer join category on cat_title=page_title+"x" where... |
11 months ago |
| select * from page full outer join category on cat_title=page_title+"x"... |
11 months ago |
| select * from page left join category on cat_title=page_title+"x" where... |
11 months ago |
| select * from page left join category on cat_title=page_title where... |
11 months ago |
| select * from page join category on cat_title=page_title where... |
11 months ago |
| select * from page join category on cat_title=page_title where... |
11 months ago |
| select * from page where page_namespace=14 and page_title like... |
11 months ago |
| select concat("Category:",page_title) from templatelinks join page on... |
11 months ago |
| select concat("Category:",page_title) from templatelinks join page on... |
11 months ago |
| select concat("Category:",page_title) from templatelinks join page on... |
11 months ago |
| blank query |
11 months ago |
| SET... |
11 months ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select user_name,count(log_id) from logging_logindex join user on... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
/*and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
/*and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select
*
from
logging_logindex
where
log_type = "rights"
and... |
1 year ago |
| select * from logging_logindex
where log_type="rights" and log_title like... |
1 year ago |
| select * from logging_logindex
where log_type="rights" and log_title like... |
1 year ago |
| select * from logging_logindex
where log_type="rights" and log_id=50740995--... |
1 year ago |
| select * from logging_logindex
where log_type="rights" and log_namespace=2... |
1 year ago |
| select * from logging_logindex join user on... |
1 year ago |
| select log_title from logging_logindex join user on... |
1 year ago |
| select * from logging_logindex join user on... |
1 year ago |
| select * from logging_logindex where log_type="rights" and log_namespace=2... |
1 year ago |
| select * from logging_logindex where log_type="rights" and log_namespace=2... |
1 year ago |
| select user_name,user_editcount from logging_logindex where... |
1 year ago |
| select user_name,user_editcount from user join user_former_groups on... |
1 year ago |
| select user_name,user_editcount from user join user_former_groups on... |
1 year ago |
| select user_name,user_editcount from user join user_former_groups on... |
1 year ago |
| select user_name,user_editcount from user join user_former_groups on... |
1 year ago |
| select rev_id,page_namespace,page_title from revision_userindex join page on... |
1 year ago |
| select page_namespace,page_title from revision_userindex join page on... |
1 year ago |
| select * from revision_userindex where rev_actor=36635239; |
1 year ago |
| select * from actor where actor_name=""; |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select user_name,user_editcount from user join user_former_groups on... |
1 year ago |
| select user_name,user_editcount from user join user_groups on... |
1 year ago |
| SELECT actor_name AS `Reviewer`, log_namespace, page_title, log_type,
... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select log_title as "Page",log_namespace as "Namespace",
(select actor_name... |
1 year ago |
| select log_title as "Page",log_namespace as "Namespace",actor_name,
(select... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",actor_name,
(select actor_name from actor_logging... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select log_title as "Page",
(select actor_name from actor_logging where... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
1 year ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
1 year ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select
log_id,
log_title
from
logging_logindex
where
log_type =... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select concat("* [[",replace(page_title,"_"," "),"]]") from page join... |
1 year ago |
| select concat("* [[",replace(page_title,"_"," "),"]]") from page join... |
1 year ago |
| select concat("* [[",replace(page_title,"_"," "),"]]") from page join... |
1 year ago |
| select concat("* [[",replace(page_title,"_"," "),"]]") from page join... |
1 year ago |
| select concat("* [[",replace(page_title,"_"," "),"]]") from page join... |
1 year ago |
| select concat("* [[",replace(page_title,"_"," ")) from page join... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title, lt_title from page join templatelinks on tl_from=page_id... |
1 year ago |
| select page_title from page where exists (select 1 from templatelinks join... |
1 year ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
2 years ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
2 years ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
2 years ago |
| blank query |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
2 years ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
2 years ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
2 years ago |
| select page_title from page where page_namespace=0 and page_is_redirect=0... |
2 years ago |
| select page_title from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select page_title from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select page_title from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| blank query |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| select
r.rev_id,
page_title
from
revision_userindex r
join page on... |
2 years ago |
| SELECT REGEXP_REPLACE(comment_text,
... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp "\)$" limit... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp ")$" limit... |
2 years ago |
| select * from page where page_namespace=0 and page_title like "%)" limit... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp... |
2 years ago |
| select * from page where page_namespace=0 and page_title regexp ".*\([A-Z]+\)$" |
2 years ago |
| select
r.rev_id,
page_title
from
revision_userindex r
join page on... |
2 years ago |
| select
r.rev_id,
page_title
from
revision_userindex r
join page on... |
2 years ago |
| select
r.rev_id,
page_title
from
revision_userindex r
join page on... |
2 years ago |
| select
r.rev_id,
page_title
from
revision_userindex r
join page on... |
2 years ago |
| select page_title, el_to, page_id from externallinks join page on... |
2 years ago |
| select page_title, el_to, page_id from externallinks join page on... |
2 years ago |
| select page_title, el_to, page_id from externallinks join page on... |
2 years ago |
| SELECT page_id,
CONCAT('[[', page_title, ']]') AS 'page title',
... |
2 years ago |
| select
r.rev_id,
page_title
from
revision_userindex r
join page on... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| /*-- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| /*-- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| /*-- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| /*-- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| /*-- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| /*-- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| -- set @thresh = NOW() - INTERVAL 6 MONTH;
-- set @mwthresh =... |
2 years ago |
| select... |
2 years ago |
| select... |
2 years ago |
