Query Run
SET @MIN_EDITS = 900; SELECT ss_total_edits FROM site_stats; SELECT... 6 months ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SET @MIN_EDITS = 700 SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SELECT ss_total_edits FROM site_stats; SELECT SUM(user_editcount) FROM... 3 years ago
SELECT ss_total_edits FROM site_stats; SELECT SUM(user_editcount) FROM... 3 years ago
blank query 3 years ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; -- SELECT user_id FROM user LIMIT 10 INTO... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; -- SELECT user_id FROM user LIMIT 10 INTO... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; -- SELECT user_id FROM user LIMIT 10 INTO... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; -- SELECT user_id FROM user LIMIT 10 INTO... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; SELECT user_id FROM user LIMIT 10 INTO... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; SELECT @x:=@x+1 LIMIT 10 INTO... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; SELECT @x:=@x+1 INTO @user_ids LIMIT... 3 years ago
SET @MIN_EDITS = 700; SET @x = 0; SELECT @x:=@x+1 INTO @user_ids LIMIT... 3 years ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
SET @MIN_EDITS = 700; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 3 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 7 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 7 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT... 7 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT * FROM ( SELECT... 7 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT * FROM ( SELECT... 7 years ago
USE rowiki_p; SELECT ss_total_edits FROM site_stats; SELECT * FROM ( SELECT... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * FROM ( SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT * from (SELECT fi.id AS userid, fi.name AS name,... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id AS userid, fi.name AS name, fi.edits AS... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT user.user_id AS id, '_' AS name, '0' AS admin, '1' AS... 7 years ago
use rowiki_p; SELECT user.user_id AS id, user.user_name AS name,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, CASE WHEN fi.admin=1 OR... 7 years ago
use rowiki_p; SELECT user.user_id AS id, user.user_name AS name,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin,... 7 years ago
use rowiki_p; SELECT user.user_id AS id, user.user_name AS name,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, MAX(fi.admin, se.admin) AS... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin,... 7 years ago
use rowiki_p; SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select * from user_properties where up_user=46238 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select user.user_id as id, user.user_name as name,... 7 years ago
use rowiki_p; select * from user inner join (select ug_user as id,... 7 years ago
use rowiki_p; select * from user inner join (select ug_user as id,... 7 years ago
use rowiki_p; select * from (select ug_user, sum(admin) as admin, sum(bot)... 7 years ago
use rowiki_p; select * from (select ug_user, sum(admin) as admin, sum(bot)... 7 years ago
use rowiki_p; select ug_user, sum(admin) as admin, sum(bot) as bot from... 7 years ago
use rowiki_p; select ug_user, sum(ap) as ap, sum(admin) as admin, sum(bot)... 7 years ago
use rowiki_p; select ug_user, sum(ap) as ap, sum(admin) as admin, sum(bot)... 7 years ago
use rowiki_p; select ug_user, sum(ap) as ap, sum(admin) as admin, sum(bot)... 7 years ago
use rowiki_p; select ug_user, sum(ap), sum(admin), sum(bot) from (select... 7 years ago
use rowiki_p; select * from (select ug_user, ug_group='autopatrolled' as ap,... 7 years ago
use rowiki_p; DECLARE @table_name varchar(max) 7 years ago
use rowiki_p; SELECT ug_user, ug_group = STUFF((SELECT DISTINCT ', ' +... 7 years ago
use rowiki_p; WITH x AS (SELECT ug_user FROM user_groups GROUP BY... 7 years ago
use rowiki_p; WITH x AS (SELECT ug_user FROM user_groups GROUP BY... 7 years ago
use rowiki_p; WITH x AS ( SELECT ug_user FROM user_groups GROUP BY... 7 years ago
use rowiki_p; select T1.Response_ID, stuff((select ','+T2.ug_group ... 7 years ago
use rowiki_p; select T1.Response_ID, stuff((select ','+T2.ug_group ... 7 years ago
use rowiki_p; select T1.Response_ID, stuff((select ','+T2.ug_group ... 7 years ago
select T1.Response_ID, stuff((select ','+T2.ug_group ... 7 years ago
use rowiki_p; select ug_user, ug_group='autopatrolled' as isap,... 7 years ago
use rowiki_p; select ug_user, ug_group='autopatrolled' as isap,... 7 years ago
use rowiki_p; select ug_user, ug_group='sysop' as isadmin, ug_group='bot' as... 7 years ago
use rowiki_p; select ug_user, ug_group='bot' as isbot from user_groups group... 7 years ago
use rowiki_p; select ug_user, concat(ug_group) as allgroups from... 7 years ago
use rowiki_p; select ug_user, sum(ug_group) as allgroups from... 7 years ago
use rowiki_p; select * from user inner join user_groups on... 7 years ago
use rowiki_p; select user.user_id, user.user_name, user.user_editcount,... 7 years ago
use rowiki_p; select user.user_id, user.user_name, user.user_editcount,... 7 years ago
use rowiki_p; select user.user_id, user.user_name, user.user_editcount,... 7 years ago
use rowiki_p; select user.user_id, user.user_name, user.user_editcount,... 7 years ago
use rowiki_p; select user.user_id, user.user_name, user.user_editcount,... 7 years ago
use rowiki_p; select user.user_id, user.user_name, user.user_editcount,... 7 years ago
use rowiki_p; select user.user_id, user.user_name, user.user_editcount,... 7 years ago
use rowiki_p; select * from user inner join user_groups on... 7 years ago
use rowiki_p; select * from user inner join user_groups on... 7 years ago
use rowiki_p; select * from user, user_groups where... 7 years ago
use rowiki_p; select * from user where user.editcount > 600 7 years ago
use rowiki_p; select * from user where user.editcount > 600 7 years ago
use rowiki_p; select * from user, user_groups where user.editcount > 600 7 years ago
use rowiki_p; select * from user, user_groups where... 7 years ago
use rowiki_p; select * from user, user_groups where... 7 years ago
use rowiki_p; select * from user_groups where user_groups.ug_group='sysop' 7 years ago
use rowiki_p; select * from user_groups 7 years ago
use rowiki_p; describe user_groups; select user_id, user_name, user_options,... 7 years ago
use rowiki_p; describe user; select user_id, user_name, user_options,... 7 years ago
use rowiki_p; describe user; select user_id, user_name, user_editcount from... 7 years ago
use rowiki_p; select user_id, user_name, user_editcount from user where... 7 years ago
use rowiki_p; select user_id, user_name, user_editcount, user_registration... 7 years ago
use rowiki_p; select user_id, user_name, user_editcount, user_registration... 7 years ago
use rowiki_p; select * from user where user_editcount > 600 7 years ago
use rowiki_p; select user_id, user_name, user_editcount, user_registration... 7 years ago
use rowiki_p; select user_id, user_name, user_editcount, user_registration... 7 years ago
use rowiki_p; select user_id, user_name, user_editcount, user_registration... 7 years ago
use rowiki_p; select user_id, user_name, user_editcount, user_registration... 7 years ago
use rowiki_p; select user_id, user_name, user_editcount, user_registration from user 7 years ago
use rowiki_p; describe user select user_id, user_name, user_editcount,... 7 years ago
use rowiki_p; describe user 7 years ago
use rowiki_p; describe rowiki_p 7 years ago
use rowiki_p; show tables from rowiki_p 7 years ago
use rowiki_p; select * from users 7 years ago
use rowiki_p; select * from user_groups 7 years ago
use rowiki_p; select * from 'user_groups' 7 years ago
use rowiki_p; select * from "user_groups" 7 years ago
use rowiki_p; show tables from rowiki_p 7 years ago
use rowiki_p; SELECT * FROM user 7 years ago
use rowiki_p; SELECT * FROM users 7 years ago
use meta_p; SELECT * FROM wiki 7 years ago
use meta_p; SELECT * FROM rowiki 7 years ago
use meta_p; SELECT * FROM wiki 7 years ago
SELECT * FROM wiki 7 years ago
SELECT "rowiki" FROM wiki 7 years ago
SELECT rowiki FROM wiki 7 years ago