SELECT DISTINCT page_title,page_namespace,actor_name FROM `recentchanges`... |
4 days ago |
SET STATEMENT max_statement_time=30 FOR SELECT DISTINCT... |
5 days ago |
SELECT
*
FROM `content`
LIMIT 10 |
5 months ago |
SELECT
*
FROM `revision`
WHERE `rev_deleted` = (2 + 4)
LIMIT 1 |
6 months ago |
SELECT
*
FROM `revision`
WHERE `rev_deleted` = (1 + 2 + 4)
LIMIT 1 |
6 months ago |
SELECT
*
FROM `revision`
WHERE `rev_deleted` & 4 = 4
LIMIT 1 |
6 months ago |
SELECT *
FROM recentchanges
WHERE rc_cur_id = 14548523 |
7 months ago |
SELECT *
FROM recentchanges
WHERE rc_cur_id = 14548523 |
7 months ago |
SELECT *
FROM recentchanges
WHERE rc_cur_id = 14548523 |
7 months ago |
SELECT COUNT(*) FROM recentchanges WHERE rc_source = "mw.new"; |
7 months ago |
SELECT COUNT(*) FROM recentchanges WHERE rc_new = "mw.new"; |
7 months ago |
SELECT COUNT(*) FROM recentchanges WHERE rc_new is null; |
7 months ago |
SELECT DISTINCT rc_source FROM recentchanges; |
7 months ago |
SELECT
COUNT(*)
FROM
ipblocks
LEFT JOIN comment ON... |
7 months ago |
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT
comment_text,
COUNT(DISTINCT comment_text)
FROM
ipblocks
LEFT... |
7 months ago |
SELECT
COUNT(*)
FROM
ipblocks
LEFT JOIN comment ON... |
7 months ago |
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SET @NOW = DATE_FORMAT(NOW(), "%Y%m%d%H%i%s"));
SELECT
*
FROM
... |
7 months ago |
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT
*
FROM
ipblocks
INNER JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT
*
FROM
ipblocks
INNER JOIN comment ON (ipblocks.ipb_reason_id =... |
7 months ago |
SELECT edit.pr_level, edit.pr_expiry = 'infinity' AS 'indefinite?',... |
8 months ago |
SELECT edit.pr_level, edit.pr_expiry = 'infinity' AS 'indefinite?',... |
8 months ago |
SELECT edit.pr_level, edit.pr_expiry = 'infinity' AS 'indefinite?',... |
8 months ago |
SELECT * FROM `archive_userindex`
WHERE ar_actor = (SELECT `actor_id`... |
8 months ago |
SELECT ar_title FROM `archive_userindex`
WHERE ar_actor = (SELECT... |
8 months ago |
SELECT ar_title FROM `archive_userindex`
WHERE ar_actor = (SELECT... |
8 months ago |
SET @ME = (SELECT `actor_id` FROM `actor` WHERE `actor_name` =... |
8 months ago |
SELECT
*,
(CAST(`main`.`rev_len` AS SIGNED) - CAST(`parent`.`rev_len`... |
8 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
COUNT(*)
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
COUNT(*)
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
*
FROM `logging_logindex`
WHERE `log_type` = "delete" AND... |
9 months ago |
SELECT
COUNT(*) AS "Total"
FROM `logging_logindex`
WHERE `log_type` =... |
9 months ago |
SELECT DISTINCT(el_to_path)
FROM externallinks
WHERE `el_to_domain_index`... |
10 months ago |
SELECT *
FROM externallinks
WHERE `el_to_domain_index` LIKE... |
10 months ago |
SELECT COUNT(*)
FROM externallinks
WHERE `el_to_domain_index` LIKE... |
10 months ago |
SELECT COUNT(*)
FROM externallinks
WHERE `el_to_domain_index` LIKE... |
10 months ago |
select * from externallinks LIMIT 5; |
10 months ago |
select distinct(up_property) from user_properties; |
10 months ago |
select distinct(up_property) from user_properties_anon; |
10 months ago |
SELECT
`status_user` as `Username`,
COUNT(1) as `Reviews`,
... |
11 months ago |
SELECT
`status_user` as `Username`,
COUNT(1) as `Reviews`,
... |
11 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(); |
3 years ago |
USE enwiki_p;
SELECT * FROM change_tag_def; |
4 years ago |
USE enwiki_p;
SELECT * FROM change_tag_def; |
4 years ago |
USE enwiki_p;
SELECT * FROM change_tag_def; |
4 years ago |
USE enwiki_p;
SELECT * FROM change_tag_def; |
4 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 |