Query Run
blank query 3 weeks ago
WITH dabs_and_redirects AS ( WITH dabs AS ( SELECT page_title AS dab ... 3 weeks ago
WITH dabs_and_redirects AS ( WITH dabs AS ( SELECT page_title AS dab ... 3 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 4 weeks ago
SET @pat='(?i).*(?!<New_)century.*financ.*'; SELECT CONCAT('[[', CASE... 1 month ago
SET @pat='(?i).*(?!<New)century.*financ.*'; SELECT CONCAT('[[', CASE... 1 month ago
SET @pat='(?i).*(?!<New)century.*financ.*'; SELECT CONCAT('[[', CASE... 1 month ago
SET @pat='(?i).*(?!<New)century.*financ.*'; SELECT CONCAT('[[', CASE... 1 month ago
SET @pat='(?i).*century.*financ.*'; SELECT CONCAT('[[', CASE... 1 month ago
SET @pat='(?i).*century.*financ'; SELECT CONCAT('[[', CASE page_namespace ... 1 month ago
select regexp_escape("a") 1 month ago
select regexp_escape("a") 1 month ago
select rescape("a") 1 month ago
select rescape("a") 1 month ago
select * from page where page_namespace=0 and page_title rlike... 1 month ago
select * from page where page_title rlike "(?i)\b(eat(s|ing)?|ate)\b.*\bshit\b" 1 month ago
select * from page where page_title rlike "(?i)\b(eat(s|ing)?|ate)\b.*\bshit\b" 1 month ago
select * from page where page_title like "%eat%shit%" 1 month ago
select "!Gã!ne" RLIKE... 1 month ago
select page_title from page where page_namespace=0 and page_title RLIKE... 1 month ago
select "!Gã!ne" rlike... 1 month ago
select "!Gã!ne" rlike... 1 month ago
select "!Gã!ne" rlike "(?i)[ℂ℃℄ɕƌʥℇ℈℉ℊℋℌℍℎℏℐ‼ℑℒℕ℗℘ℙℚℛℜℝ℞℟℣ℤℨ℩ℬℭ℮ℯℰℱℲℳℴℹ℺⅁⅂⅃⅄ⅅⅆⅇⅈⅉⅎ]" 1 month ago
select * from page where page_namespace=0 and page_title rlike "(?i)ℂ.*"; 1 month ago
select * from page where page_namespace=0 and page_title rlike "(?i)ℂ.*"; 1 month ago
select * from page where page_namespace=0 and page_title rlike "(?i).*ℂ.*"; 1 month ago
select * from page where page_namespace=0 and page_title like "%ℂ%"; 1 month ago
select * from protected_titles where pt_namespace=0 and pt_title like "A%"; 1 month ago
select count(*) from protected_titles where pt_namespace=0 and pt_title like "A%"; 1 month ago
select count(*) from protected_titles where pt_namespace=0 and pt_title like "A%"; 1 month ago
select count(*) from protected_titles where pt_namespace=0; 1 month ago
select count(*) from protected_titles where pt_namespace=0 and... 1 month ago
select count(*) from protected_titles where pt_namespace=0; 1 month ago
select * from page where page_namespace=0 and page_title like... 1 month ago
select * from page where page_namespace=0 and page_title like... 1 month ago
select * from protected_titles where pt_namespace=0 limit 10 1 month ago
select page_title from page where page_namespace=0 and page_is_redirect=0... 1 month ago
select page_title from page where page_namespace=0 and page_is_redirect=0... 1 month ago
select page_title from page where page_namespace=0 and page_is_redirect=0... 1 month ago
SELECT art.page_title, REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... 1 month ago
SELECT art.page_title, REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... 1 month ago
blank query 1 month ago
SELECT art.page_title, REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... 1 month ago
blank query 1 month ago
SELECT art.page_title, REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... 1 month ago
SET @pat='(?i).*object.*show'; SELECT CONCAT('[[', CASE page_namespace ... 1 month ago
SET @pat='(?i)(.*guest.*characters*)'; SELECT page_title, EXISTS... 2 months ago
SET @pat='(?i).*guest.*characters'; SELECT CONCAT('[[', CASE... 2 months ago
select page_title from revision_userindex join page on rev_page=page_id... 2 months ago
select * from revision_userindex where rev_actor=374 and rev_comment_id=10... 2 months ago
select * from revision_userindex where rev_actor=374 and rev_comment_id=10... 2 months ago
select * from revision_userindex where rev_actor=374 and rev_comment_id=10 limit 500; 2 months ago
select * from revision_userindex where rev_actor=374 and rev_comment_id=10; 2 months ago
select * from revision_userindex where rev_actor=374 and rev_comment=10; 2 months ago
select * from revision_compat where rev_page=60136700 2 months ago
select * from revision where rev_page=60136700 2 months ago
select page_namespace,page_title,cl_timestamp from categorylinks join page... 3 months ago
select page_namespace,page_title,cl_timestamp from categorylinks join page... 3 months ago
select log_title as 'Page', (select actor_name from actor_logging where... 3 months ago
select log_title as 'Page', (select actor_name from actor_logging where... 3 months ago
select log_title as 'Page', (select actor_name from actor_logging where... 3 months ago
select comment_text from actor_archive join archive on ar_actor=actor_id... 3 months ago
select comment_text from actor_archive join archive on ar_actor=actor_id... 3 months ago
select comment_text from actor_archive join archive on ar_actor=actor_id... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
select... 3 months ago
SET @cat = 'Proposed deletion as of 1 February 2024'; SELECT DISTINCT... 3 months ago
SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS... 3 months ago
blank query 3 months ago
SET @pat='(?i).*g.*marchand.*'; SELECT CONCAT('[[', CASE page_namespace ... 3 months ago
SET @pat='(?i).*greg.*marchand.*'; SELECT CONCAT('[[', CASE page_namespace ... 3 months ago
SET @pat='.*greg.*marchand.*'; SELECT CONCAT('[[', CASE page_namespace ... 3 months ago
SET @pat='.*greg.*marchand.*'; SELECT CONCAT('[[', CASE page_namespace ... 3 months ago
select page_namespace,page_title,cl_timestamp from categorylinks join page... 3 months ago
SELECT CAST(MIN(rev_timestamp) AS DATETIME) AS '1st edit', page_title FROM... 3 months ago
SELECT CAST(MIN(rev_timestamp) AS DATETIME) AS '1st edit', page_title FROM... 3 months ago
select concat("Category:",page_title) from templatelinks join page on... 3 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select... 4 months ago
select user_name,user_editcount from user join user_groups on... 4 months ago
select * from page right join category on cat_title=page_title where... 4 months ago
select * from page where page_namespace=14 and exists (select 1 from... 4 months ago
select * from page where page_namespace=14 and not exists (select 1 from... 4 months ago
select * from page right join category on cat_title=page_title+"x" where... 4 months ago
select * from page outer join category on cat_title=page_title+"x" where... 4 months ago
select * from page outer join category on cat_title=page_title+"x" where... 4 months ago
select * from page outer join category on cat_title=page_title+"x" where... 4 months ago
select * from page full outer join category on cat_title=page_title+"x"... 4 months ago
select * from page left join category on cat_title=page_title+"x" where... 4 months ago
select * from page left join category on cat_title=page_title where... 4 months ago
select * from page join category on cat_title=page_title where... 4 months ago
select * from page join category on cat_title=page_title where... 4 months ago
select * from page where page_namespace=14 and page_title like... 4 months ago
select concat("Category:",page_title) from templatelinks join page on... 4 months ago
select concat("Category:",page_title) from templatelinks join page on... 4 months ago
select concat("Category:",page_title) from templatelinks join page on... 4 months ago
blank query 4 months ago
SET... 4 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... 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
blank query 1 year ago
select * from page where page_namespace=0 and page_title regexp... 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 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_title regexp... 1 year ago
select page_title from page where page_namespace=0 and page_title regexp... 1 year ago
select page_title from page where page_namespace=0 and page_title regexp... 1 year ago
select... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
blank query 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
select r.rev_id, page_title from revision_userindex r join page on... 1 year ago
SELECT REGEXP_REPLACE(comment_text, ... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp "\)$" limit... 1 year ago
select * from page where page_namespace=0 and page_title regexp ")$" limit... 1 year ago
select * from page where page_namespace=0 and page_title like "%)" limit... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp... 1 year ago
select * from page where page_namespace=0 and page_title regexp ".*\([A-Z]+\)$" 1 year ago
select r.rev_id, page_title from revision_userindex r join page on... 1 year ago
select r.rev_id, page_title from revision_userindex r join page on... 1 year ago
select r.rev_id, page_title from revision_userindex r join page on... 1 year ago
select r.rev_id, page_title from revision_userindex r join page on... 1 year ago
select page_title, el_to, page_id from externallinks join page on... 1 year ago
select page_title, el_to, page_id from externallinks join page on... 1 year ago
select page_title, el_to, page_id from externallinks join page on... 1 year ago
SELECT page_id, CONCAT('[[', page_title, ']]') AS 'page title', ... 1 year ago
select r.rev_id, page_title from revision_userindex r join page on... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
/*-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
/*-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
/*-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
/*-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
/*-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
/*-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
-- set @thresh = NOW() - INTERVAL 6 MONTH; -- set @mwthresh =... 1 year ago
select... 1 year ago
select... 1 year ago