Query Run
SELECT CONCAT("Template:", lt_title) as tmpl, COUNT(*) as cnt FROM... 1 year ago
SELECT page_namespace, page_title, page_len FROM page WHERE page_len >... 1 year ago
SELECT page_namespace, page_title, page_len FROM page WHERE page_len >... 1 year ago
SELECT page_namespace, page_title, page_len FROM page WHERE page_len >... 1 year ago
-- -- 2 years ago
select rc_title, comment_text from `recentchanges` join `comment` on... 2 years ago
select rc_title, comment_text from `recentchanges` join `comment` on... 3 years ago
select rc_title, comment_text from `recentchanges` join `comment` on... 3 years ago
select rc_title, comment_text from `recentchanges` join `comment` on... 3 years ago
select rc_title, comment_text from `recentchanges` join `comment` on... 3 years ago
select rc_title, comment_text from `recentchanges` join `comment` on... 3 years ago
select rc_title, comment_text from `recentchanges` join `comment` on... 3 years ago
select * from recentchanges where rc_type in (0, 1) and rc_patrolled = 0 limit 10; 3 years ago
select count(*) from recentchanges where rc_type = 0 and rc_patrolled = 0 limit 10; 3 years ago
select * from recentchanges where rc_type = 0 and rc_patrolled = 0 limit 10; 3 years ago
select * from recentchanges limit 10; 3 years ago
select * from recentchances limit 10; 3 years ago
-- -- 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname;... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname;... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname;... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname;... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname;... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname;... 3 years ago
/* SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname;... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY pp_propname; /*... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(pp_page) FROM page_props GROUP BY... 3 years ago
SELECT pp_propname, COUNT(page_id) FROM page JOIN page_props ON pp_page =... 3 years ago
SELECT pp_propname -- , COUNT(page_id) FROM page JOIN page_props ON pp_page... 3 years ago
SELECT pp_propname -- , COUNT(page_id) FROM page JOIN page_props ON pp_page... 3 years ago
SELECT pp_progname -- , COUNT(page_id) FROM page JOIN page_props ON pp_page... 3 years ago
SELECT * -- ppp.pp_progname -- , COUNT(page_id) FROM page JOIN page_props ON... 3 years ago
SELECT ppp.pp_progname -- , COUNT(page_id) FROM page JOIN page_props AS... 3 years ago
SELECT ppp.pp_progname -- , COUNT(page_id) FROM page JOIN page_props AS... 3 years ago
SELECT pp_progname -- , COUNT(page_id) FROM page JOIN page_props ON pp_page... 3 years ago
SELECT * -- pp_progname, COUNT(page_id) FROM page JOIN page_props ON pp_page... 3 years ago
SELECT * -- pp_progname, COUNT(page_id) FROM page JOIN page_props ON pp_page... 3 years ago
SELECT * -- pp_progname, COUNT(page_id) FROM page JOIN page_props ON pp_page... 3 years ago
SELECT pp_progname, COUNT(page_id) FROM page JOIN page_props ON pp_page =... 3 years ago
SELECT * FROM page JOIN page_props ON pp_page = page_id LIMIT 10; 3 years ago
SELECT 5*9; 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... 3 years ago
Select 3; 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS... 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") as... 3 years ago
SET @ct:=0; SELECT CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") as... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1 as r, CONCAT("{{u|",user,"}}") as... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1 as r, CONCAT("{{u|",user,"}}") as... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1 as r, CONCAT("{{u|",user,"}}") as... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1, user, cnt FROM ( SELECT actor_name AS user, ... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1, * FROM ( SELECT actor_name AS user, ... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1 FROM ( SELECT actor_name AS user, ... 3 years ago
SET @ct:=0; SELECT @ct FROM ( SELECT @ct, actor_name AS user, ... 3 years ago
SET @ct:=0; SELECT @ct FROM ( SELECT @ct, actor_name AS user, ... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1 FROM ( SELECT @ct, actor_name AS user, ... 3 years ago
SET @ct:=0; SELECT @ct:=@ct+1 FROM ( SELECT ct, actor_name AS user, ... 3 years ago
-- SET @ct:=0; -- select @ct:=@ct+1 from ( SELECT actor_name AS user, ... 3 years ago
SET @ct:=0; select @ct:=@ct+1 from ( SELECT actor_name AS user, ... 3 years ago
SET @ct:=0; select @ct:=@ct+1, actor_name from ( SELECT actor_name AS... 3 years ago
SET @ct:=0; select @ct:=@ct+1, actor_name from ( SELECT actor_name AS... 3 years ago
SET @ct:=0; select @ct:=@ct+1, actor_name from ( SELECT actor_name AS... 3 years ago
SET @ct:=0; select @ct:=@ct+1, actor_name from ( SELECT actor_name AS... 3 years ago
SET @ct:=0; select @ct:=@ct+1, * from ( SELECT actor_name AS user, ... 3 years ago
SELECT actor_name AS user, COUNT(rev_id) AS cnt FROM actor INNER JOIN... 3 years ago
SELECT actor_name AS user, COUNT(rev_id) AS cnt, ROW_NUMBER() OVER... 3 years ago
SELECT actor_name AS user, COUNT(rev_id) AS cnt, ROW_NUMBER() OVER... 3 years ago
SELECT ROW_NUMBER() OVER (PARTITION BY user ORDER BY cnt Desc), actor_name... 3 years ago
SET @r:=0; SELECT @r AS rank, actor_name AS user, COUNT(rev_id) AS... 3 years ago
SET @r:=0; SELECT @r:=@r+1 AS rank, actor_name AS user, COUNT(rev_id)... 3 years ago
SET @cnt:=0; SELECT @cnt:=@cnt+1 AS rank, actor_name AS user, ... 3 years ago
SET @cnt:=0; SELECT @cnt:=@cnt+1 AS rank actor_name AS user, ... 3 years ago
SET @cnt:=0; SELECT @cnt:=@cnt+1, rc_id from recentchanges limit 5; 3 years ago
SET @counter:=0; SELECT @counter:=@counter+1, rc_id from recentchanges limit 5; 3 years ago
select rc_id from recentchanges limit 5; 3 years ago