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 |