Query Run
SELECT * FROM `content` LIMIT 10 4 months ago
SELECT * FROM `revision` WHERE `rev_deleted` = (2 + 4) LIMIT 1 5 months ago
SELECT * FROM `revision` WHERE `rev_deleted` = (1 + 2 + 4) LIMIT 1 5 months ago
SELECT * FROM `revision` WHERE `rev_deleted` & 4 = 4 LIMIT 1 5 months ago
SELECT * FROM recentchanges WHERE rc_cur_id = 14548523 5 months ago
SELECT * FROM recentchanges WHERE rc_cur_id = 14548523 5 months ago
SELECT * FROM recentchanges WHERE rc_cur_id = 14548523 5 months ago
SELECT COUNT(*) FROM recentchanges WHERE rc_source = "mw.new"; 5 months ago
SELECT COUNT(*) FROM recentchanges WHERE rc_new = "mw.new"; 5 months ago
SELECT COUNT(*) FROM recentchanges WHERE rc_new is null; 5 months ago
SELECT DISTINCT rc_source FROM recentchanges; 5 months ago
SELECT COUNT(*) FROM ipblocks LEFT JOIN comment ON... 6 months ago
SELECT * FROM ipblocks LEFT JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT comment_text, COUNT(DISTINCT comment_text) FROM ipblocks LEFT... 6 months ago
SELECT COUNT(*) FROM ipblocks LEFT JOIN comment ON... 6 months ago
SELECT * FROM ipblocks LEFT JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT * FROM ipblocks LEFT JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SET @NOW = DATE_FORMAT(NOW(), "%Y%m%d%H%i%s")); SELECT * FROM ... 6 months ago
SELECT * FROM ipblocks LEFT JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT * FROM ipblocks LEFT JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT * FROM ipblocks LEFT JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT * FROM ipblocks LEFT JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT * FROM ipblocks INNER JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT * FROM ipblocks INNER JOIN comment ON (ipblocks.ipb_reason_id =... 6 months ago
SELECT edit.pr_level, edit.pr_expiry = 'infinity' AS 'indefinite?',... 6 months ago
SELECT edit.pr_level, edit.pr_expiry = 'infinity' AS 'indefinite?',... 6 months ago
SELECT edit.pr_level, edit.pr_expiry = 'infinity' AS 'indefinite?',... 6 months ago
SELECT * FROM `archive_userindex` WHERE ar_actor = (SELECT `actor_id`... 6 months ago
SELECT ar_title FROM `archive_userindex` WHERE ar_actor = (SELECT... 6 months ago
SELECT ar_title FROM `archive_userindex` WHERE ar_actor = (SELECT... 6 months ago
SET @ME = (SELECT `actor_id` FROM `actor` WHERE `actor_name` =... 6 months ago
SELECT *, (CAST(`main`.`rev_len` AS SIGNED) - CAST(`parent`.`rev_len`... 6 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT COUNT(*) FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT COUNT(*) FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "delete" AND... 8 months ago
SELECT COUNT(*) AS "Total" FROM `logging_logindex` WHERE `log_type` =... 8 months ago
SELECT DISTINCT(el_to_path) FROM externallinks WHERE `el_to_domain_index`... 9 months ago
SELECT * FROM externallinks WHERE `el_to_domain_index` LIKE... 9 months ago
SELECT COUNT(*) FROM externallinks WHERE `el_to_domain_index` LIKE... 9 months ago
SELECT COUNT(*) FROM externallinks WHERE `el_to_domain_index` LIKE... 9 months ago
select * from externallinks LIMIT 5; 9 months ago
select distinct(up_property) from user_properties; 9 months ago
select distinct(up_property) from user_properties_anon; 9 months ago
SELECT `status_user` as `Username`, COUNT(1) as `Reviews`, ... 10 months ago
SELECT `status_user` as `Username`, COUNT(1) as `Reviews`, ... 10 months ago
select `log_id`, `log_timestamp`, `log_params`, (SELECT... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT MAX(`log_timestamp`) FROM `logging_logindex` LEFT JOIN... 1 year ago
SELECT MAX(`log_timestamp`) FROM `logging_logindex` LEFT JOIN... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT COUNT(*) FROM `logging_logindex` LEFT JOIN `actor_logging` ON... 1 year ago
SELECT COUNT(*) FROM `logging_logindex` LEFT JOIN `actor_logging` ON... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT COUNT(*) FROM `logging_logindex` LEFT JOIN `actor_logging` ON... 1 year ago
SELECT COUNT(*) FROM `logging_logindex` LEFT JOIN `actor_logging` ON... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT COUNT(*) FROM logging_logindex WHERE log_type = 'delete' AND... 1 year ago
SELECT * FROM logging_logindex WHERE log_type = 'delete' AND log_action =... 1 year ago
SELECT * FROM logging_logindex WHERE log_type = 'delete' AND log_action =... 1 year ago
SELECT * FROM logging_logindex WHERE log_action = 'delete/revision' LIMIT 5; 1 year ago
SELECT * FROM logging_logindex WHERE log_type = 'delete' AND log_action =... 1 year ago
SELECT * FROM logging WHERE log_type = 'delete' AND log_action =... 1 year ago
SELECT * FROM log WHERE log_type = 'delete' AND log_action = 'delete/revision'; 1 year ago
SELECT * FROM categorylinks LIMIT 1; 1 year ago
-- start: 1096861007 -- end: 1173359127 SET @START = 1096861007; SELECT ... 1 year ago
-- start: 1096861007 -- end: 1173359127 SET @START = 1096861007; SELECT ... 1 year ago
-- start: 1096861007 -- end: 1173359127 SET @START = 1096861007; SELECT ... 1 year ago
SELECT `comment_id` FROM `comment_revision` WHERE `comment_text` LIKE... 1 year ago
SELECT `rev_id` as "ID" FROM `revision_userindex` JOIN... 1 year ago
SELECT `rev_id` as "ID" FROM `revision_userindex` JOIN... 1 year ago
SELECT * FROM langlinks WHERE ll_from = 9228 LIMIT 20 1 year ago
SELECT el_to_domain_index, el_to_path, ... 1 year ago
SELECT el_to_domain_index, el_to_path, ... 1 year ago
SELECT el_to_domain_index, el_to_path, ... 1 year ago
SELECT el_to_domain_index, el_to_path, ... 1 year ago
SELECT el_to_domain_index, el_to_path, ... 1 year ago
SELECT el_to_domain_index, el_to_path, CONCAT(el_to_domain_index,... 1 year ago
SELECT el_to_domain_index, el_to_path, CONCAT(el_to_domain_index,... 1 year ago
SELECT el_to_domain_index, el_to_path, CONCAT(el_to_domain_index,... 1 year ago
SELECT el_to_domain_index, el_to_path, CONCAT(el_to_domain_index,... 1 year ago
SELECT el_to_domain_index, el_to_path, CONCAT(el_to_domain_index,... 1 year ago
SELECT el_to_domain_index, el_to_path, CONCAT(el_to_domain_index,... 1 year ago
SELECT el_to_domain_index, el_to_path, CONCAT(el_to_domain_index,... 1 year ago
SELECT el_to_domain_index, el_to_path, as CONCAT(el_to_domain_index,... 1 year ago
SELECT * FROM externallinks LIMIT 1 1 year ago
SELECT * FROM revision JOIN page ON rev_page = page_id WHERE rev_deleted < 8... 1 year ago
SELECT * FROM revision JOIN page ON rev_page = page_id WHERE rev_deleted < 8... 1 year ago
SELECT * FROM revision JOIN page ON rev_page = page_id WHERE rev_deleted < 8... 1 year ago
SELECT * FROM revision JOIN page ON rev_page = page_id WHERE rev_deleted = 4 LIMIT 1 1 year ago
SELECT COUNT(*) FROM revision WHERE rev_page = (SELECT page_id FROM page... 1 year ago
SELECT DISTINCT `log_action` FROM `logging` WHERE `log_type` = "delete" AND... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` LEFT JOIN `logging_logindex` pd ON ... 1 year ago
SELECT * FROM `archive_userindex` RIGHT JOIN `logging_logindex` pd ON... 1 year ago
SELECT * FROM `archive_userindex` RIGHT JOIN `logging_logindex` pd ON... 1 year ago
SELECT * FROM `archive_userindex` RIGHT JOIN `logging_logindex` pd ON... 1 year ago
SELECT * FROM `archive_userindex` RIGHT JOIN `logging_logindex` pd ON... 1 year ago
SELECT * FROM `logging_userindex` WHERE `log_type` = "create" AND... 1 year ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "create" AND `log_actor`... 1 year ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "create" ORDER BY... 1 year ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "create" ORDER BY... 1 year ago
SELECT * FROM `logging_logindex` WHERE `log_type` = "create" AND... 1 year ago
SELECT * FROM `logging` WHERE `log_type` = "create" AND `log_action` =... 1 year ago
SELECT * FROM `logging` WHERE `log_type` = "create" `log_action` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` =... 1 year ago
SELECT VERSION(); 2 years ago
USE enwiki_p; SELECT * FROM change_tag_def; 3 years ago
USE enwiki_p; SELECT * FROM change_tag_def; 3 years ago
USE enwiki_p; SELECT * FROM change_tag_def; 3 years ago
USE enwiki_p; SELECT * FROM change_tag_def; 3 years ago
USE enwiki_p; SELECT * FROM revision_userindex INNER JOIN change_tag ON... 4 years ago
USE enwiki_p; SELECT * FROM revision_userindex JOIN change_tag ON ct_rev_id... 4 years ago
USE enwiki_p; SELECT * FROM revision_userindex LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM revision_userindex LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM revision LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM archive LIMIT 1; 4 years ago
USE enwiki_p; SHOW TABLES; -- SELECT * FROM content LIMIT 1; 4 years ago
USE enwiki_p; -- SHOW TABLES; SELECT * FROM content LIMIT 1; 4 years ago
USE enwiki_p; SHOW TABLES; -- SELECT * FROM revision LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM page LIMIT 1; 4 years ago
USE enwiki_p; SHOW TABLES; -- SELECT * FROM revision LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM text LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM revision LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM revisions LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM revision_userindex LIMIT 1; 4 years ago
USE enwiki_p; SELECT * FROM revision_userindex LIMIT `; 4 years ago
USE mgwiktionary_p; SELECT SUM(user_editcount) FROM `user`; 4 years ago
USE mgwiktionary_p; SELECT SUM(user_editcount) FROM `user` LEFT JOIN... 4 years ago
USE mgwiktionary_p; SELECT SUM(user_editcount) FROM `user` LEFT JOIN... 4 years ago
USE mgwiktionary_p; SELECT SUM(user_editcount) FROM `user` LEFT JOIN... 4 years ago
USE mgwiktionary_p; SELECT SUM(user_editcount) FROM `user` JOIN user_groups... 4 years ago
USE mgwiktionary_p; SELECT SUM(user_editcount) FROM `user` JOIN user_groups... 4 years ago
USE mgwiktionary_p; SELECT SUM(user_editcount) FROM `user` JOIN user_group... 4 years ago
USE mgwiktionary_p; SELECT * FROM user_groups LIMIT 1; 4 years ago
USE mgwiktionary_p; SELECT * FROM `user` LIMIT 1; 4 years ago
USE mgwiktionary_p; SELECT * FROM user_groups LIMIT 1; 4 years ago
USE mgwiktionary_p; SHOW TABLES; 4 years ago
USE mgwiktionary_p; SELECT actor_name as `Username`, ... 4 years ago
USE mgwiktionary_p; SELECT actor_name as `Username`, ... 4 years ago
USE mgwiktionary_p; SELECT * FROM revision_userindex LIMIT 1; 4 years ago
USE mgwiktionary_p; SELECT actor_name as `Username`, ... 4 years ago
SHOW DATABASES; 4 years ago
LIST DATABASES; 4 years ago
USE enwiki_p; SELECT * FROM `revision` LIMIT 1; 4 years ago
USE enwiki_p; SHOW TABLES; 4 years ago