| SET @pat='(?i)\\bs(\\b.*\\b)?m\\b.*hasan';
WITH ns(ns_n, ns_s) AS (VALUES... |
17 hours ago |
| SET @pat='(?i)\\bs(\\b.*\\b)?m\b.*hasan';
WITH ns(ns_n, ns_s) AS (VALUES... |
17 hours ago |
| SET @pat='(?i)\bs\b.*\bm\b.*hasan';
WITH ns(ns_n, ns_s) AS (VALUES (-2,... |
18 hours ago |
| SET @pat='(?i)s.*m.*hasan';
WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'),... |
18 hours ago |
| select replace(convert(page_title,char),"_"," ") from page where... |
1 day ago |
| select replace(convert(page_title,char),"_"," ") from page where... |
1 day ago |
| select replace(convert(page_title,char),"_"," ") from page where... |
1 day ago |
| select * from page where replace(convert(page_title,char),"_"," ") RLIKE... |
1 day ago |
| select * from page where page_title like "%BITCH%" and page_namespace=0 |
1 day ago |
| select "aa" like "__%" |
1 day ago |
| select "a" like "__%" |
1 day ago |
| select replace(page_title,"_"," ") from page where page_namespace=0 and... |
1 day ago |
| select replace(page_title,"_"," ") from page where page_namespace=0 and... |
1 day ago |
| select replace(page_title,"_"," ") from page where... |
1 day ago |
| select replace(page_title,"_"," ") from page where replace(page_title,"_","... |
1 day ago |
| select replace(page_title,"_"," ") from page where page_title regexp... |
1 day ago |
| select "\"Weird Al\" Yankovic Live! – The Alpocalypse Tour" regexp... |
1 day ago |
| select "!Dame! !Dame! !Dame!" regexp "(?i)[!?‽¿]\\s+[!?‽¿]" |
1 day ago |
| select "!Dame!_!Dame!_!Dame!" regexp "(?i)[!?‽¿]\\s+[!?‽¿]" |
1 day ago |
| select * from page where page_namespace=0 and page_title regexp... |
1 day ago |
| select * from page where page_namespace=0 and page_title regexp... |
1 day ago |
| select * from page where page_namespace=0 and page_title regexp... |
1 day ago |
| select * from page where page_namespace=0 and page_title regexp... |
1 day ago |
| select * from page where page_namespace=0 and convert(page_title,CHAR)... |
1 day ago |
| select * from page where page_namespace=0 and convert(page_title,CHAR)... |
1 day ago |
| select * from page where convert(page_title,CHAR) regexp "\\p{Cc}" limit 10; |
1 day ago |
| select * from page where convert(page_title as utf8) regexp "\\p{Cc}" limit 10; |
1 day ago |
| select * from page where page_title regexp "\\p{Cc}" limit 10; |
1 day ago |
| select count(*) from page where page_title regexp "\\p{Cc}"; |
1 day ago |
| select "" regexp "\p{Cc}"; |
1 day ago |
| select "abc" regexp ".*cruǐzǐn\.*" |
1 day ago |
| select * from redirect where rd_interwiki is null; |
2 days ago |
| select * from redirect where rd_interwiki is null; |
2 days ago |
| select * from redirect where rd_interwiki =''; |
2 days ago |
| select * from redirect where rd_interwiki is null; |
2 days ago |
| select * from revtag where rt_page=2200704; |
2 days ago |
| select * from page where page_namespace=1198 and (select count(*) from... |
2 days ago |
| select * from revision where rev_page=6231165 and rev_len < 1000; |
2 days ago |
| select * from revision where rev_page=6231165 and rev_len < 1000; |
2 days ago |
| SET @pat='(?i).*ipd.*tamil.*';
WITH ns(ns_n, ns_s) AS (VALUES (-2,... |
4 days ago |
| SET @pat='(?i).*\bgp\b.*records';
WITH ns(ns_n, ns_s) AS (VALUES (-2,... |
5 days ago |
| SET @pat='(?i).*gp.*records';
WITH ns(ns_n, ns_s) AS (VALUES (-2,... |
5 days ago |
| SELECT concat(... |
6 days ago |
| select page_namespace,page_title from page where page_title like "Broken/%"; |
1 week ago |
| select page_namespace,page_title from page where page_title like "Broken/%"; |
1 week ago |
| select page_namespace,page_title from page where page_title like "Broken/%"; |
1 week ago |
| SET @pat='(?i).*kera.*28.*';
WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'),... |
1 week ago |
| SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text
FROM... |
1 week ago |
| SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text
FROM... |
1 week ago |
| describe globaluser; |
2 weeks ago |
| show tables; |
2 weeks ago |
| select page_namespace,page_title,page_len from page where page_title like... |
2 weeks ago |
| select * from page where page_title like "%LQT_Archive_1" and page_len > 100; |
2 weeks ago |
| select * from page where page_title like "%LQT Archive 1%" and page_len > 100; |
2 weeks ago |
| SET @pat='(?i)nitish.*nirmal';
WITH ns(ns_n, ns_s) AS (VALUES (-2,... |
2 weeks ago |
| SET @pat='(?i)nitish.*nirmal';
WITH ns(ns_n, ns_s) AS (VALUES (-2,... |
2 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id,log_type from user_groups join user on... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select actor_name,log_id from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| select DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH),... |
3 weeks ago |
| select actor_name from user_groups join user on user_id=ug_user join... |
3 weeks ago |
| WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'), (-1, 'Special:'), (0, ''),... |
3 weeks ago |
| select * from wb_items_per_site where ips_site_id like "%yue%" limit 100; |
3 weeks ago |
| select * from wb_items_per_site where ips_site_id like "%nan%" limit 100; |
3 weeks ago |
| select * from wb_items_per_site where ips_site_id like "nan%" limit 100; |
3 weeks ago |
| select * from wb_items_per_site where ips_site_id="zh-min-nanwikinews" limit 100; |
3 weeks ago |
| select * from wb_items_per_site where ips_site_id="nanwikinews" limit 100; |
3 weeks ago |
| select other.ips_site_id,other.ips_site_page,target.ips_site_page
from... |
3 weeks ago |
| select other.ips_site_page,target.ips_site_page
from wb_items_per_site... |
3 weeks ago |
| select other.ips_site_page_2 from wb_items_per_site target join... |
3 weeks ago |
| select * from wb_items_per_site target join wb_items_per_site other on... |
3 weeks ago |
| select * from wb_items_per_site where ips_site_id="shnwikinews" limit 10; |
3 weeks ago |
| select * from wb_items_per_site limit 10; |
3 weeks ago |
| select * from wb_items_per_site limit 10; |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title regexp... |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title regexp... |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title regexp... |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title regexp... |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title like... |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title like... |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title like... |
3 weeks ago |
| select * from page p1 where page_namespace=10 and page_title like... |
3 weeks ago |
| select * from logging_logindex join comment_logging on... |
1 month ago |
| select * from logging_logindex join comment_logging on... |
1 month ago |
| select * from logging_logindex join comment_logging on... |
1 month ago |
| select * from logging_logindex join comment_logging on... |
1 month ago |
| select * from archive where ar_namespace=4 and ar_title like "Featured%"; |
1 month ago |
| SELECT CONCAT('[[Special:Redirect/logid/',log_id,']]') AS id,
... |
1 month ago |
| select page_namespace,page_title,cl_timestamp from categorylinks join page... |
2 months ago |
| select user_name, user_editcount from user join user_groups on ug_user =... |
3 months ago |
| select
distinct page_title
from
globalimagelinks
join page on... |
4 months ago |
| select
distinct page_title
from
globalimagelinks
join page on... |
4 months ago |
| select
distinct page_title
from
globalimagelinks
join page on... |
4 months ago |
| select
distinct page_title
from
globalimagelinks
join page on... |
4 months ago |
| select
page_title
from
globalimagelinks
join page on page_namespace =... |
4 months ago |
| select
*
from
globalimagelinks
where
gil_wiki = "metawiki"
limit 100; |
4 months ago |
| select
page_title
from
globalimagelinks
join page on page_namespace =... |
4 months ago |
| select * from globalusage limit 100; |
4 months ago |
| select
page_title
from
globalimagelinks
join page on page_namespace =... |
4 months ago |
| select
page_title
from
globalimagelinks
join page on page_namespace =... |
4 months ago |
| select
page_title
from
globalimagelinks
join page on page_namespace =... |
4 months ago |
| select page_title from globalimagelinks
join page on page_namespace=6 and... |
4 months ago |
| select page_title from globalimagelinks
join page on page_namespace=6 and... |
4 months ago |
| select page_title from globalimagelinks
join page on page_namespace=6 and... |
4 months ago |
| select page_title, cl_to from globalimagelinks
join page on page_namespace=6... |
4 months ago |
| select page_title, cl_to from globalimagelinks
join page on page_namespace=6... |
4 months ago |
| select page_title, cl_to from globalimagelinks
join page on page_namespace=6... |
4 months ago |
| select * from globalimagelinks where gil_wiki="metawiki" and gil_page=12682308; |
4 months ago |
| select * from globalimagelinks limit 20;
|
4 months ago |
| select * from globalimagelinks limit 20;
select * from globalimagelinks... |
4 months ago |
| select * from globalimagelinks;
select * from globalimagelinks where... |
4 months ago |
| select * from globalimagelinks where gil_wiki="metawiki" and gil_page_id=12682308; |
4 months ago |
| select * from globalimagelinks where gil_wiki="metawiki" and... |
4 months ago |
| select * from globalimagelinks limit 10; |
4 months ago |
| select * from globalusage limit 10; |
4 months ago |
| select distinct concat('User:',lt_title) from templatelinks join linktarget... |
5 months ago |
| select distinct concat('User:',lt_title) from templatelinks join linktarget... |
5 months ago |
| select distinct concat('User:',lt_title) from templatelinks join linktarget... |
5 months ago |
| select distinct concat('User:',tl_title) from templatelinks where... |
5 months ago |
| SELECT img.page_title
FROM categorylinks AS c1
JOIN page AS img ON... |
6 months ago |
| SELECT img.page_title
FROM categorylinks AS c1
JOIN page AS img ON... |
6 months ago |
| select * from langlinks where ll_title != (select page_title from page where... |
6 months ago |
| select * from langlinks where ll_title != (select page_title from page where... |
6 months ago |
| select * from langlinks where ll_title != (select page_title from page where... |
6 months ago |
| select * from langlinks where ll_title != (select page_title from page where... |
6 months ago |
| select * from langlinks where ll_title != (select page_title from page where... |
6 months ago |
| select * from langlinks where ll_title != (select page_title from page where... |
6 months ago |
| select * from langlinks limit 1000; |
6 months ago |
| select * from langlinks where ll_from=76889989 limit 1000; |
6 months ago |
| select * from iwlinks where iwl_from=76889989 limit 1000; |
6 months ago |
| select * from iwlinks where iwl_from=76889989 limit 1000; |
6 months ago |
| select * from iwlinks limit 1000; |
6 months ago |
| select page_title from page where page_title LIKE... |
6 months ago |
| select log_namespace as "Namespace",log_title as "Page",
(select actor_name... |
6 months ago |
| select log_namespace as "Namespace",log_title as "Page",
(select actor_name... |
6 months ago |
| select log_namespace as "Namespace",log_title as "Page",
(select actor_name... |
6 months ago |
| select log_namespace as "Namespace",log_title as "Page",
(select actor_name... |
6 months ago |
| select log_namespace as "Namespace",log_title as "Page",
(select actor_name... |
6 months ago |
|
select log_namespace as "Namespace",log_title as "Page",
(select actor_name... |
6 months ago |
| WITH dabs_and_redirects AS (
WITH dabs AS (
SELECT page_title AS dab
... |
6 months ago |
| WITH dabs_and_redirects AS (
WITH dabs AS (
SELECT page_title AS dab
... |
6 months ago |
| WITH dabs_and_redirects AS (
WITH dabs AS (
SELECT page_title AS dab
... |
6 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
6 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
6 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
6 months ago |
| SELECT P1.page_title, P2.page_title
FROM page P2
JOIN page P1 ON... |
6 months ago |
| SELECT P1.page_title, P2.page_title
FROM page P2
JOIN page P1 ON... |
6 months ago |
| select rev_id from revision where rev_page=24122344;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=24122344;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=24122344;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=76766586;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=76766586;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=76766586;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=76766127;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=76766127;
select ar_rev_id from... |
6 months ago |
| select rev_id from revision where rev_page=76766127;
select ar_rev_id from... |
6 months ago |
| select * from block join block_target on bt_id=bl_target join comment on... |
7 months ago |
| select * from block join block_target on bt_id=bl_target_id join comment on... |
7 months ago |
| select * from block join comment on bl_reason_id=comment_id where... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p2.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p2.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p2.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p2.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p2.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p2.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
p1.page_title
FROM page as p1
JOIN page AS p2 ON (... |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| blank query |
7 months ago |
| SELECT
CONCAT(CASE p1.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN... |
7 months ago |
| blank query |
7 months ago |
| SELECT art.page_title,
REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... |
7 months ago |
| SELECT art.page_title,
REGEXP_REPLACE(art.page_title, '\\.+$', '') AS... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select * from page join protected_titles on page_title like... |
7 months ago |
| select
*
from
page
where
page_namespace = 0
and page_title like "aaa%"; |
7 months ago |
| select
*
from
page
where
page_namespace = 0
and page_title like "aaa%"; |
7 months ago |
| select * from protected_titles where pt_namespace=0 and exists (select 1... |
7 months ago |
| select * from protected_titles limit 10; |
7 months ago |
| select * from protectedtitles limit 10; |
7 months ago |
| select * from archive where ar_namespace=118 and ar_title like... |
7 months ago |
| select * from archive where ar_namespace=118 and ar_title like... |
7 months ago |
| select * from archive where ar_namespace=118 and ar_title like... |
7 months ago |
| select * from archive where ar_namespace=118 and ar_title like... |
7 months ago |
| SELECT
page_title
FROM
page
WHERE
page_title LIKE '%(animal)'
and... |
7 months ago |
| SELECT page_title
FROM page
WHERE page_title LIKE '%(animal)' and... |
7 months ago |
| SELECT page_title
FROM page
WHERE page_title LIKE '%(animal)' and... |
7 months ago |
| SELECT page_title
FROM page
WHERE page_title LIKE '%(animal)' and... |
7 months ago |
| SELECT page_title
FROM page
WHERE page_title LIKE '%(animal)'
GROUP BY... |
7 months ago |
| SET @pat='(?i)n.*circle';
SELECT CONCAT('[[', CASE page_namespace
... |
7 months ago |
| SET @pat='(?i).*p.*ri.*ch.*';
SELECT CONCAT('[[', CASE page_namespace
... |
7 months ago |
| SET @pat='(?i).*p.*ri.*ch.*';
SELECT CONCAT('[[', CASE page_namespace
... |
7 months ago |
| SET @pat='(?i).*p.*ri.*ch.*';
SELECT CONCAT('[[', CASE page_namespace
... |
7 months ago |
| /* Disabled due to low use */ |
7 months ago |
| select * from page where page_namespace = 0 and page_is_redirect=0 and... |
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... |
9 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... |
9 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... |
9 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... |
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... |
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_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 |
