Query Run
# USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 11 months ago
# USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 3 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
USE mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
/* use mediawikiwiki_p; /**/ SELECT a.actor_name, e.edits, ... 4 years ago
/* use mediawikiwiki_p; /**/ SELECT a.actor_name, e.edits, ... 4 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 4 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 5 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 5 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 5 years ago
use mediawikiwiki_p; SELECT a.actor_name, e.edits, e.last_edit, ... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp)... 5 years ago
use mediawikiwiki_p; SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp) AS... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', MAX(rc.rc_timestamp) AS... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', MAX(rc.rc_timestamp) AS... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', rc.*, actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT COUNT(*) AS 'edits', actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT rc_timestamp, actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT rc_timestamp, rc_actor, actor.* FROM... 5 years ago
use mediawikiwiki_p; SELECT * FROM recentchanges_userindex JOIN actor ON... 5 years ago
use mediawikiwiki_p; SELECT * FROM recentchanges_userindex JOIN actor ON... 5 years ago
use mediawikiwiki_p; SELECT * FROM recentchanges_userindex LIMIT 100 5 years ago
SELECT * FROM recentchanges_userindex LIMIT 100 5 years ago
DESCRIBE recentchanges_userindex 5 years ago
USE frwiki_p; SELECT DISTINCT ug_group FROM user_groups #SELECT * FROM... 5 years ago
USE aawiki_p; SELECT DISTINCT ug_group FROM user_groups #SELECT * FROM... 5 years ago
#SELECT DISTINCT ug_group FROM user_groups SELECT * FROM user_groups WHERE... 5 years ago
SELECT DISTINCT ug_group FROM user_groups 5 years ago
SELECT DISTINCT user_groups FROM ug_group 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
#USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE metawiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE simplewiki_p; SELECT log_type, log_action, actor.actor_name, COUNT(*) AS... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, actor.actor_name,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, actor.actor_name,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, actor.actor_name,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, actor.actor_name,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, actor.actor_name,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, actor.actor_name,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, log_timestamp,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, log_actor,... 5 years ago
USE simplewiktionary_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE simplewiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; #SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; #SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT log_type, log_action, log_title, log_actor,... 5 years ago
USE metawiki_p; SELECT * FROM logging #GROUP BY CONCAT(log_type, log_action) LIMIT 10 5 years ago
USE metawiki_p; SELECT * FROM logging GROUP BY CONCAT(log_type, log_action) 5 years ago
USE metawiki_p; SELECT * FROM logging GROUP BY CONCAT(log_type, log_action) LIMIT 1 5 years ago
USE metawiki_p; SELECT * FROM logging GROUP BY CONCAT(log_type, log_action) LIMIT 100 5 years ago
USE metawiki_p; SELECT * FROM logging LIMIT 100 5 years ago
SELECT page.page_id, page.page_namespace, page.page_title FROM page ... 5 years ago
SELECT page.page_id, page.page_namespace, page.page_title FROM page ... 5 years ago
SELECT page.page_id, page.page_namespace, page.page_title FROM page ... 5 years ago
SELECT page.page_id, page.page_namespace, page.page_title FROM page ... 5 years ago
SELECT page.page_id, page.page_namespace, page.page_title FROM page ... 5 years ago
SELECT page.page_id, page.page_title, page.page_namespace FROM page ... 5 years ago
SELECT page.page_id, page.page_title FROM page LEFT JOIN... 5 years ago
SELECT page.page_id, page.page_title FROM page LEFT JOIN... 5 years ago
SELECT page.page_id, page.page_title FROM page LEFT JOIN... 5 years ago
SELECT page.page_id, page.page_title FROM page LEFT JOIN... 5 years ago
SELECT page.page_id AS 'Source page_id', page.page_title AS 'Source... 5 years ago
SELECT page.page_id AS 'Source page_id', page.page_title AS 'Source... 5 years ago
SELECT page.page_id AS 'Source page_id', page.page_title AS 'Source... 5 years ago
SELECT page.page_id AS 'Source page_id', page.page_title AS 'Source... 5 years ago
SELECT page.page_id AS 'Source page_id', page.page_title AS 'Source... 5 years ago
SELECT * FROM page WHERE page_namespace <> 828 AND page_content_model =... 5 years ago
SELECT * FROM page WHERE page_namespace <> 828 AND page_content_model = 'Scribunto' 5 years ago
SELECT * FROM page WHERE page_namespace = 828 AND page_content_model = 'Scribunto' 5 years ago
SELECT COUNT(*) FROM page WHERE page_namespace = 828 AND page_content_model... 5 years ago
SELECT * FROM page WHERE page_namespace = 828 AND page_content_model = 'Scribunto' 5 years ago
SELECT * FROM page WHERE page_namespace = 828 AND page_content_model =... 5 years ago
SELECT * FROM page WHERE page_namespace = 828 LIMIT 100 5 years ago
SELECT * FROM page WHERE page_namespace = 828 5 years ago
SELECT DISTINCT page_namespace FROM page 5 years ago
SELECT user_id, user_name, user_groups.ug_group FROM user LEFT JOIN... 5 years ago
SELECT user_id, user_name, user_groups.ug_group FROM user LEFT JOIN... 5 years ago
SELECT * FROM user WHERE user_id IN (SELECT ug_user FROM user_groups WHERE... 5 years ago
SELECT * FROM user WHERE user_id IN (SELECT ug_user FROM user_groups WHERE... 5 years ago
SELECT * FROM user_groups LEFT JOIN user ON ug_user = user_id LIMIT 100 5 years ago
SELECT *, user.user_name FROM user_groups LEFT JOIN user ON ug_user =... 5 years ago
SELECT *, user.* FROM user_groups LEFT JOIN user ON ug_user = user_id LIMIT 100 5 years ago
SELECT * FROM user_groups LIMIT 100 5 years ago
SELECT * FROM user LIMIT 100 5 years ago
SELECT * FROM LIMIT 100 5 years ago
SELECT * FROM user_groups LIMIT 100 5 years ago