Query Run
SET @pat='(?i).*b\\.?f\\.?d\\.?i.*'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 week ago
SET @pat='(?i).*b\.?f\.?d\.?i.*'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 week ago
SET @pat='(?i).*miss.*inter.*continental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 2 weeks ago
SET @pat='(?i).*miss.*inter.*continental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 2 weeks ago
SET @pat='(?i).*Arshin.*Mehta.*'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 3 weeks ago
SET @pat='(?i).*antony.*gordon.*'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 3 weeks ago
SET @pat='(?i).*miss.*inter.*continental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 3 weeks ago
SET @pat='(?i).*miss.*inter.+continental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 3 weeks ago
SET @pat='(?i).*miss.*inter.*continental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 3 weeks ago
SET @pat='(?i).*mr?s.*inter.*continental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 3 weeks ago
SET @pat='(?i).*miss.*inter.*continental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 3 weeks ago
SET @pat='(?i).*miss.*intercontinental.*'; WITH ns(ns_n, ns_s) AS (VALUES... 3 weeks ago
select count(*) from logging_logindex join comment_logging on... 3 weeks ago
select count(*) from logging_logindex join comment_logging on... 3 weeks ago
select count(*) from logging_logindex join comment_logging on... 3 weeks ago
select count(*) from logging_logindex join comment_logging on... 3 weeks ago
select count(*) from logging_logindex join comment_logging on... 3 weeks ago
SET @pat='(?i)\\bs(\\b.*\\b)?m\\b.*hasan'; WITH ns(ns_n, ns_s) AS (VALUES... 1 month ago
SET @pat='(?i)\\bs(\\b.*\\b)?m\b.*hasan'; WITH ns(ns_n, ns_s) AS (VALUES... 1 month ago
SET @pat='(?i)\bs\b.*\bm\b.*hasan'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 month ago
SET @pat='(?i)s.*m.*hasan'; WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'),... 1 month ago
select replace(convert(page_title,char),"_"," ") from page where... 1 month ago
select replace(convert(page_title,char),"_"," ") from page where... 1 month ago
select replace(convert(page_title,char),"_"," ") from page where... 1 month ago
select * from page where replace(convert(page_title,char),"_"," ") RLIKE... 1 month ago
select * from page where page_title like "%BITCH%" and page_namespace=0 1 month ago
select "aa" like "__%" 1 month ago
select "a" like "__%" 1 month ago
select replace(page_title,"_"," ") from page where page_namespace=0 and... 1 month ago
select replace(page_title,"_"," ") from page where page_namespace=0 and... 1 month ago
select replace(page_title,"_"," ") from page where... 1 month ago
select replace(page_title,"_"," ") from page where replace(page_title,"_","... 1 month ago
select replace(page_title,"_"," ") from page where page_title regexp... 1 month ago
select "\"Weird Al\" Yankovic Live! – The Alpocalypse Tour" regexp... 1 month ago
select "!Dame! !Dame! !Dame!" regexp "(?i)[!?‽¿]\\s+[!?‽¿]" 1 month ago
select "!Dame!_!Dame!_!Dame!" regexp "(?i)[!?‽¿]\\s+[!?‽¿]" 1 month ago
select * from page where page_namespace=0 and page_title regexp... 1 month ago
select * from page where page_namespace=0 and page_title regexp... 1 month ago
select * from page where page_namespace=0 and page_title regexp... 1 month ago
select * from page where page_namespace=0 and page_title regexp... 1 month ago
select * from page where page_namespace=0 and convert(page_title,CHAR)... 1 month ago
select * from page where page_namespace=0 and convert(page_title,CHAR)... 1 month ago
select * from page where convert(page_title,CHAR) regexp "\\p{Cc}" limit 10; 1 month ago
select * from page where convert(page_title as utf8) regexp "\\p{Cc}" limit 10; 1 month ago
select * from page where page_title regexp "\\p{Cc}" limit 10; 1 month ago
select count(*) from page where page_title regexp "\\p{Cc}"; 1 month ago
select "" regexp "\p{Cc}"; 1 month ago
select "abc" regexp ".*cruǐzǐn\.*" 1 month ago
select * from redirect where rd_interwiki is null; 1 month ago
select * from redirect where rd_interwiki is null; 1 month ago
select * from redirect where rd_interwiki =''; 1 month ago
select * from redirect where rd_interwiki is null; 1 month ago
select * from revtag where rt_page=2200704; 1 month ago
select * from page where page_namespace=1198 and (select count(*) from... 1 month ago
select * from revision where rev_page=6231165 and rev_len < 1000; 1 month ago
select * from revision where rev_page=6231165 and rev_len < 1000; 1 month ago
SET @pat='(?i).*ipd.*tamil.*'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 month ago
SET @pat='(?i).*\bgp\b.*records'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 month ago
SET @pat='(?i).*gp.*records'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 month ago
SELECT concat(... 1 month ago
select page_namespace,page_title from page where page_title like "Broken/%"; 1 month ago
select page_namespace,page_title from page where page_title like "Broken/%"; 1 month ago
select page_namespace,page_title from page where page_title like "Broken/%"; 1 month ago
SET @pat='(?i).*kera.*28.*'; WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'),... 1 month ago
SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text FROM... 1 month ago
SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text FROM... 1 month ago
describe globaluser; 1 month ago
show tables; 1 month ago
select page_namespace,page_title,page_len from page where page_title like... 1 month ago
select * from page where page_title like "%LQT_Archive_1" and page_len > 100; 1 month ago
select * from page where page_title like "%LQT Archive 1%" and page_len > 100; 1 month ago
SET @pat='(?i)nitish.*nirmal'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 month ago
SET @pat='(?i)nitish.*nirmal'; WITH ns(ns_n, ns_s) AS (VALUES (-2,... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id,log_type from user_groups join user on... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select actor_name,log_id from user_groups join user on user_id=ug_user join... 1 month ago
select DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH),... 1 month ago
select actor_name from user_groups join user on user_id=ug_user join... 1 month ago
WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'), (-1, 'Special:'), (0, ''),... 1 month ago
select * from wb_items_per_site where ips_site_id like "%yue%" limit 100; 1 month ago
select * from wb_items_per_site where ips_site_id like "%nan%" limit 100; 1 month ago
select * from wb_items_per_site where ips_site_id like "nan%" limit 100; 1 month ago
select * from wb_items_per_site where ips_site_id="zh-min-nanwikinews" limit 100; 1 month ago
select * from wb_items_per_site where ips_site_id="nanwikinews" limit 100; 1 month ago
select other.ips_site_id,other.ips_site_page,target.ips_site_page from... 1 month ago
select other.ips_site_page,target.ips_site_page from wb_items_per_site... 1 month ago
select other.ips_site_page_2 from wb_items_per_site target join... 1 month ago
select * from wb_items_per_site target join wb_items_per_site other on... 1 month ago
select * from wb_items_per_site where ips_site_id="shnwikinews" limit 10; 1 month ago
select * from wb_items_per_site limit 10; 1 month ago
select * from wb_items_per_site limit 10; 1 month ago
select * from page p1 where page_namespace=10 and page_title regexp... 1 month ago
select * from page p1 where page_namespace=10 and page_title regexp... 1 month ago
select * from page p1 where page_namespace=10 and page_title regexp... 1 month ago
select * from page p1 where page_namespace=10 and page_title regexp... 1 month ago
select * from page p1 where page_namespace=10 and page_title like... 1 month ago
select * from page p1 where page_namespace=10 and page_title like... 1 month ago
select * from page p1 where page_namespace=10 and page_title like... 1 month ago
select * from page p1 where page_namespace=10 and page_title like... 1 month ago
select * from logging_logindex join comment_logging on... 2 months ago
select * from logging_logindex join comment_logging on... 2 months ago
select * from logging_logindex join comment_logging on... 2 months ago
select * from logging_logindex join comment_logging on... 2 months ago
select * from archive where ar_namespace=4 and ar_title like "Featured%"; 2 months ago
SELECT CONCAT('[[Special:Redirect/logid/',log_id,']]') AS id, ... 2 months ago
select page_namespace,page_title,cl_timestamp from categorylinks join page... 3 months ago
select user_name, user_editcount from user join user_groups on ug_user =... 4 months ago
select distinct page_title from globalimagelinks join page on... 5 months ago
select distinct page_title from globalimagelinks join page on... 5 months ago
select distinct page_title from globalimagelinks join page on... 5 months ago
select distinct page_title from globalimagelinks join page on... 5 months ago
select page_title from globalimagelinks join page on page_namespace =... 5 months ago
select * from globalimagelinks where gil_wiki = "metawiki" limit 100; 5 months ago
select page_title from globalimagelinks join page on page_namespace =... 5 months ago
select * from globalusage limit 100; 5 months ago
select page_title from globalimagelinks join page on page_namespace =... 5 months ago
select page_title from globalimagelinks join page on page_namespace =... 5 months ago
select page_title from globalimagelinks join page on page_namespace =... 5 months ago
select page_title from globalimagelinks join page on page_namespace=6 and... 5 months ago
select page_title from globalimagelinks join page on page_namespace=6 and... 5 months ago
select page_title from globalimagelinks join page on page_namespace=6 and... 5 months ago
select page_title, cl_to from globalimagelinks join page on page_namespace=6... 5 months ago
select page_title, cl_to from globalimagelinks join page on page_namespace=6... 5 months ago
select page_title, cl_to from globalimagelinks join page on page_namespace=6... 5 months ago
select * from globalimagelinks where gil_wiki="metawiki" and gil_page=12682308; 5 months ago
select * from globalimagelinks limit 20; 5 months ago
select * from globalimagelinks limit 20; select * from globalimagelinks... 5 months ago
select * from globalimagelinks; select * from globalimagelinks where... 5 months ago
select * from globalimagelinks where gil_wiki="metawiki" and gil_page_id=12682308; 5 months ago
select * from globalimagelinks where gil_wiki="metawiki" and... 5 months ago
select * from globalimagelinks limit 10; 5 months ago
select * from globalusage limit 10; 5 months ago
select distinct concat('User:',lt_title) from templatelinks join linktarget... 6 months ago
select distinct concat('User:',lt_title) from templatelinks join linktarget... 6 months ago
select distinct concat('User:',lt_title) from templatelinks join linktarget... 6 months ago
select distinct concat('User:',tl_title) from templatelinks where... 6 months ago
SELECT img.page_title FROM categorylinks AS c1 JOIN page AS img ON... 7 months ago
SELECT img.page_title FROM categorylinks AS c1 JOIN page AS img ON... 7 months ago
select * from langlinks where ll_title != (select page_title from page where... 7 months ago
select * from langlinks where ll_title != (select page_title from page where... 7 months ago
select * from langlinks where ll_title != (select page_title from page where... 7 months ago
select * from langlinks where ll_title != (select page_title from page where... 7 months ago
select * from langlinks where ll_title != (select page_title from page where... 7 months ago
select * from langlinks where ll_title != (select page_title from page where... 7 months ago
select * from langlinks limit 1000; 7 months ago
select * from langlinks where ll_from=76889989 limit 1000; 7 months ago
select * from iwlinks where iwl_from=76889989 limit 1000; 7 months ago
select * from iwlinks where iwl_from=76889989 limit 1000; 7 months ago
select * from iwlinks limit 1000; 7 months ago
select page_title from page where page_title LIKE... 7 months ago
select log_namespace as "Namespace",log_title as "Page", (select actor_name... 7 months ago
select log_namespace as "Namespace",log_title as "Page", (select actor_name... 7 months ago
select log_namespace as "Namespace",log_title as "Page", (select actor_name... 7 months ago
select log_namespace as "Namespace",log_title as "Page", (select actor_name... 7 months ago
select log_namespace as "Namespace",log_title as "Page", (select actor_name... 7 months ago
select log_namespace as "Namespace",log_title as "Page", (select actor_name... 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
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 P1.page_title, P2.page_title FROM page P2 JOIN page P1 ON... 7 months ago
SELECT P1.page_title, P2.page_title FROM page P2 JOIN page P1 ON... 7 months ago
select rev_id from revision where rev_page=24122344; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=24122344; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=24122344; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=76766586; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=76766586; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=76766586; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=76766127; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=76766127; select ar_rev_id from... 7 months ago
select rev_id from revision where rev_page=76766127; select ar_rev_id from... 7 months ago
select * from block join block_target on bt_id=bl_target join comment on... 8 months ago
select * from block join block_target on bt_id=bl_target_id join comment on... 8 months ago
select * from block join comment on bl_reason_id=comment_id where... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p2.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p2.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p2.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p2.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p2.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p2.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT p1.page_title FROM page as p1 JOIN page AS p2 ON (... 8 months ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 8 months ago
blank query 8 months ago
SELECT CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... 8 months ago
blank query 8 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
select * from page join protected_titles on page_title like... 8 months ago
select * from page join protected_titles on page_title like... 8 months ago
select * from page join protected_titles on page_title like... 8 months ago
select * from page join protected_titles on page_title like... 8 months ago
select * from page join protected_titles on page_title like... 8 months ago
select * from page join protected_titles on page_title like... 8 months ago
select * from page join protected_titles on page_title like... 8 months ago
select * from page join protected_titles on page_title like... 8 months ago
select * from page where page_namespace = 0 and page_title like "aaa%"; 8 months ago
select * from page where page_namespace = 0 and page_title like "aaa%"; 8 months ago
select * from protected_titles where pt_namespace=0 and exists (select 1... 8 months ago
select * from protected_titles limit 10; 8 months ago
select * from protectedtitles limit 10; 8 months ago
select * from archive where ar_namespace=118 and ar_title like... 8 months ago
select * from archive where ar_namespace=118 and ar_title like... 8 months ago
select * from archive where ar_namespace=118 and ar_title like... 8 months ago
select * from archive where ar_namespace=118 and ar_title like... 8 months ago
SELECT page_title FROM page WHERE page_title LIKE '%(animal)' and... 8 months ago
SELECT page_title FROM page WHERE page_title LIKE '%(animal)' and... 8 months ago
SELECT page_title FROM page WHERE page_title LIKE '%(animal)' and... 8 months ago
SELECT page_title FROM page WHERE page_title LIKE '%(animal)' and... 8 months ago
SELECT page_title FROM page WHERE page_title LIKE '%(animal)' GROUP BY... 8 months ago
SET @pat='(?i)n.*circle'; SELECT CONCAT('[[', CASE page_namespace ... 8 months ago
SET @pat='(?i).*p.*ri.*ch.*'; SELECT CONCAT('[[', CASE page_namespace ... 8 months ago
SET @pat='(?i).*p.*ri.*ch.*'; SELECT CONCAT('[[', CASE page_namespace ... 8 months ago
SET @pat='(?i).*p.*ri.*ch.*'; SELECT CONCAT('[[', CASE page_namespace ... 8 months ago
/* Disabled due to low use */ 8 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 9 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 10 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 10 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 10 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 10 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 10 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 10 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 10 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 11 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 12 months ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 1 year ago
select * from page where page_namespace = 0 and page_is_redirect=0 and... 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 not regexp... 1 year ago
select log_title,comment_text as "Page" from logging_logindex join comment... 1 year ago
select log_title,comment_text as "Page" from logging_logindex join comment... 1 year ago
select log_title as "Page" from logging_logindex where log_type="delete" and... 1 year ago
select log_title as "Page", comment_text as "Edit summary" from... 1 year ago
select log_title as "Page", comment_text as "Edit summary", from... 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 * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex join page on page_namespace=log_namespace... 1 year ago
select * from logging_userindex where log_actor=(select actor_id from... 1 year ago
select * from logging_userindex where log_actor=(select actor_id from... 1 year ago
select page_title, user_name from pagetriage_page join page on... 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_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, x,(select max(x) from cat) from (select page_title,... 1 year ago
select page_title, x,max(select x from cat) from (select page_title,... 1 year ago
select page_title, x,max(select x from cat) from (select page_title,... 1 year ago
select page_id=max(page_id) from page limit 10; 1 year ago
select max(page_id) from page limit 10; 1 year ago
select max(page_id from page) limit 10; 1 year ago
select max(page_id from page) limit 10; 1 year ago
select max(page_id from page) limit 10; 1 year ago
select max(page_id from page) limit 10; 1 year ago
select page_title, x from (select page_title, ROW_NUMBER() OVER(ORDER BY... 1 year ago
select page_title, x from (select page_title, ROW_NUMBER() OVER(ORDER BY... 1 year ago
select page_title, x from (select page_title, ROW_NUMBER() OVER(ORDER BY... 1 year ago
select page_title, x,max(x) from (select page_title, ROW_NUMBER() OVER(ORDER... 1 year ago
select page_title, x from (select page_title, ROW_NUMBER() OVER(ORDER BY... 1 year ago
select page_title, x from (select page_title, ROW_NUMBER() OVER(ORDER BY... 1 year ago
select page_title, x from (select page_title, ROW_NUMBER() as x from page... 1 year ago
select page_title from (select page_title from page where page_namespace=2... 1 year ago
select page_title from (select page_title from page where page_namespace=2... 1 year ago
select page_title from (select page_title from page where page_namespace=2... 1 year ago
select page_title, x, min(x),max(x) from (select page_title from page where... 1 year ago
select page_title, x, min(x),max(x) from (select page_title, 1 as x ... 1 year ago
select page_title, x, min(x),max(x) from (select page_title, ROW_NUMBER()... 1 year ago
select page_title, no, min(no),max(no) from (select page_title, ROW_NUMBER()... 1 year ago
select page_title,ROW_NUMBER() OVER(ORDER BY (SELECT 1)), max(ROW_NUMBER()... 1 year ago
select page_title from page where page_namespace=2 and page_title like 'Pppery%'; 1 year ago
select page_title,page_title=min(page_title),page_title=max(page_title) from... 1 year ago
select count(*) from logging_logindex where log_type="delete" and... 1 year ago
select count(*) from logging_logindex where log_type="delete" and... 1 year ago
select count(*) from logging_logindex where log_type="delete" and... 1 year ago
select count(*) from logging_logindex where log_type="delete" and... 1 year ago
select count(*) from logging_logindex where log_type="delete" and... 1 year ago
select count(*) from logging_logindex where log_type="delete" and... 1 year ago
select count(*) from logging_logindex where log_type="delete" and... 1 year ago
select page_title, cl_to from page inner join categorylinks on cl_from =... 1 year ago
select page_title, cl_to from page inner join categorylinks on cl_from =... 1 year ago
select page_title, cl_to from page inner join categorylinks on cl_from =... 1 year ago
SHOW EXPLAIN for all; 1 year ago
SHOW EXPLAIN for all; 1 year ago
SHOW EXPLAIN 1 year ago
select... 1 year ago
select... 1 year ago
select... 1 year ago
select... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\""),log_params from... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\"") from logging_logindex where... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\",s:") from logging_logindex... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\",s:[0-9]+") from... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\"") from logging_logindex where... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\"" from logging_logindex where... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\") from logging_logindex where... 1 year ago
select REGEXP_SUBSTR(log_params,"4::target\",s:[0-9]+:\"(.*?\"),") from... 1 year ago
select * from logging_logindex where log_type="move" order by log_timestamp... 1 year ago
select * from logging_logindex where log_type="move" limit 1; 1 year ago
SELECT ar_timestamp AS "Time created", actor_name AS "Editor created", ... 1 year ago
SELECT ar_timestamp AS "Time created", actor_name AS "Editor created", ... 1 year ago
SELECT ar_timestamp AS "Time created", actor_name AS "Editor created", ... 1 year ago
SELECT Lc.log_title AS "Title created", Lc.log_timestamp AS "Time created",... 1 year ago
select log_id,rev_id,log_title from logging_logindex join page on... 1 year ago
select log_id,rev_id,log_title from logging_logindex join page on... 2 years ago
select concat("* [[:",log_title) from logging_logindex join page on... 2 years ago
select log_id,log_title from logging_logindex join page on page_namespace=0... 2 years ago
select log_id,log_title from logging_logindex join page on page_namespace=0... 2 years ago
select log_id,log_title from logging_logindex join page on page_namespace=0... 2 years ago
select log_id,log_title from logging_logindex join page on page_namespace=0... 2 years ago
select log_id,log_title from logging_logindex join page on page_namespace=0... 2 years ago
select log_id,log_title,(select comment_text from comment_logging where... 2 years ago
select * from logging_logindex join page on page_namespace=0 and... 2 years ago
select * from logging_logindex where log_namespace=0 and... 2 years ago
select * from logging_logindex where log_namespace=0 and... 2 years ago
select * from logging_logindex where log_namespace=0 and... 2 years ago
select * from logging_logindex where log_namespace=0 and... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
SELECT user_name, SUM(rev_ids) AS `live`, SUM(ar_ids) AS `deleted`,... 2 years ago
SELECT user_name, SUM(rev_ids) AS `live`, SUM(ar_ids) AS `deleted`,... 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 user_name, user_editcount from user_groups join user on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_namespace, page_title, user_name from pagetriage_page join page... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select page_title, user_name from pagetriage_page join page on... 2 years ago
select * from pagetriage_page join page on page_id=ptrp_page_id where... 2 years ago
select page_title from pagetriage_page join page on... 2 years ago
select page_title from pagetriage_page where ptrp_reviewed=3 join page on... 2 years ago
select * from pagetriage_page where ptrp_reviewed=3 limit 1; 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text FROM... 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 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 rev_id, (select page_title from page where page_id=rev_page) from... 2 years ago
select rev_id, (select page_title from page where page_id=rev_page) from... 2 years ago
select rev_id, (select page_title from page where page_id=rev_page) from... 2 years ago
select rev_id, (select page_title from page where page_id=rev_id) from... 2 years ago
select rev_id, (select page_title from page where page_id=rev_id) from... 2 years ago
select rev_id from revision_userindex r where rev_actor=(select actor_id... 2 years ago
select rev_id from revision_userindex r where rev_actor=(select actor_id... 2 years ago
select rev_id from revision_userindex r where rev_actor=(select actor_id... 2 years ago
select * from revision_userindex where rev_actor=(select actor_id from... 2 years ago
select... 2 years ago
select... 2 years ago
select... 2 years ago
select * from templatelinks where tl_from_namespace=4 and tl_namespace=1 and... 2 years ago
select * from templatelinks where tl_from_namespace=4 and tl_namespace=1 limit 100; 2 years ago
select page_title, (select count(*) from templatelinks where tl_namespace=10... 2 years ago
select page_title, (select count(*) from templatelinks where tl_namespace=10... 2 years ago
select page_title, (select count(*) from templatelinks where tl_namespace=10... 2 years ago
select count(*) from templatelinks where tl_namespace=10 and... 2 years ago
select count(*) from templatelinks where tl_namespace=10 and tl_title="Cite... 2 years ago
select count(*) from templatelinks where tl_namespace=14 and tl_title="Cite... 2 years ago
select page_title,rev_id from logging_userindex join page on... 2 years ago
select page_title,rev_id from logging_userindex where... 2 years ago
select * from logging_userindex where log_type="pagetriage-curation" and... 2 years ago
select * from logging_userindex where log_type="pagetriage-curation" and... 2 years ago
select * from logging_userindex where log_type="pagetriage-curation" and... 2 years ago
select * from logging_logindex where log_type="pagetriage-curation" and... 2 years ago
select * from logging_logindex where log_type=pagetriage_curation and... 2 years ago
select distinct concat('User:',tl_title) from templatelinks where... 2 years ago
select distinct concat('User:',tl_title) from templatelinks where... 2 years ago
select distinct concat('User:',tl_title) from templatelinks where... 2 years ago
select distinct concat('User:',tl_title) from templatelinks where... 2 years ago
select distinct concat('User:',tl_title) from templatelinks where... 2 years ago
select distinct concat('User:',tl_title) from templatelinks where... 2 years ago
select distinct (select concat("User:",page_title) from page where... 2 years ago
select * from templatelinks where tl_from_namespace=2 and tl_namespace=0 limit 10; 2 years ago
select * from archive_compat where ar_namespace=0 and ar_title="Mali_Beč" 2 years ago
select * from archive_compat where ar_namespace=0 and ar_title="Mali Beč" 2 years ago
blank query 2 years ago
select count(*) as "Speedy deletes" from logging_userindex join... 2 years ago
select count(*) as "Speedy deletes" from logging_userindex join... 2 years ago
select count(*) from logging_userindex join actor_logging on... 2 years ago
select concat("Category:",page_title),page_len,cat_pages,cat_subcats from... 2 years ago
select concat("Category:",page_title),page_len,cat_pages,cat_subcats from... 2 years ago
select page_title from page cat where page_namespace=14 and page_title... 2 years ago
select page_title from page cat where page_namespace=14 and page_title... 2 years ago
select page_title from page cat where page_namespace=14 and page_title... 2 years ago
select page_title from page cat where page_namespace=14 and page_title... 2 years ago
select page_title from page cat where page_namespace=14 and page_title... 2 years ago
select page_title from page cat where page_namespace=14 and page_title... 2 years ago
select page_title from page cat where page_namespace=14 and page_title... 2 years ago
select page_title,pl_title from page cat where page_namespace=14 and... 2 years ago
select page_title,pl_title from page cat join pagelinks on... 2 years ago
select page_title,pl_title from page cat join pagelinks on... 2 years ago
select page_title,pl_title from page cat join pagelinks on... 2 years ago
select pahe_title,pl_title from page cat join pagelinks on... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat join pagelinks on pl_from=page_id where... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page cat where page_namespace=14 and page_title regexp... 2 years ago
select * from page where page_namespace=14 and page_title like... 2 years ago
select * from page where page_namespace=14 and page_title like... 2 years ago
select * from page where page_namespace=14 and page_title like "%Wikipedians%oppose"; 2 years ago
select * from page where page_namespae=14 and page_title like "%Wikipedians%oppose"; 2 years ago