Query Run
SELECT COUNT(*), TRIM(LEADING 'www.' FROM... 3 years ago
SELECT ipb_address, ipb_by_actor, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT ipb_address, ipb_by_actor, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT ipb_address, ipb_by_actor, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT ipb_address, ipb_by_actor, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT ipb_address, ipb_by_actor, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT ipb_address, ipb_by_actor, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT ipb_address, ipb_by_text, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT ipb_address, ipb_timestamp, ipb_expiry, 0 - DATEDIFF(NOW(),... 3 years ago
SELECT ipb_address, ipb_timestamp, ipb_expiry, 0 - DATEDIFF(NOW(),... 3 years ago
SELECT ipb_address, ipb_timestamp, ipb_expiry, 0 - DATEDIFF(NOW(),... 3 years ago
SELECT ipb_address, ipb_timestamp, ipb_expiry, 0 - DATEDIFF(NOW(),... 3 years ago
SELECT ipb_address, ipb_timestamp, ipb_expiry, 0 - DATEDIFF(NOW(),... 3 years ago
SHOW INDEX IN ipblocks; 3 years ago
SELECT * FROM ipblocks; LIMIT 10; 3 years ago
DESCRIBE ipblocks; 3 years ago
DESCRIBE ip_changes; 3 years ago
select actor_name from actor_recentchanges; 3 years ago
DESCRIBE actor_recentchanges; 3 years ago
DESCRIBE flaggedrevs_stats; 3 years ago
DESCRIBE page; 3 years ago
SELECT * FROM flaggedrevs_statistics; 3 years ago
SHOW TABLES; 3 years ago
DESCRIBE idwiki_p; 3 years ago
DESCRIBE externallinks; 3 years ago
SELECT img_name FROM image WHERE NOT EXISTS (SELECT ... 3 years ago
SELECT img_name FROM image WHERE NOT EXISTS (SELECT ... 3 years ago
SELECT page_namespace, ns_name, page_title, COUNT(*) FROM... 3 years ago
SELECT page_namespace, ns_name, page_title, COUNT(*) FROM... 3 years ago
SELECT actor_name, log_namespace, log_timestamp, log_action, ... 3 years ago
SELECT COUNT(DISTINCT rd_from) FROM redirect INNER JOIN page ON... 3 years ago
SELECT ipb_address, ipb_timestamp, ipb_expiry, FROM ipblocks WHERE... 3 years ago
SELECT ipb_address, ipb_timestamp, ipb_expiry, ipb_reason FROM... 3 years ago
SELECT ipb_address, ipb_by_text, ipb_timestamp, ipb_expiry, ... 3 years ago
SELECT comment_text, COUNT(log_id) AS uses FROM logging JOIN `comment`... 3 years ago
SELECT page_namespace, page_title, page_len FROM page LEFT JOIN... 3 years ago
SELECT p1.page_namespace, p1.page_title FROM page AS p1 WHERE... 3 years ago
SELECT page_namespace, MAX(notredir), MAX(redir) FROM ( SELECT... 3 years ago
SELECT page_namespace, ns_name, page_title, COUNT(*) FROM... 3 years ago
SELECT page_namespace, page_title, page_len FROM page WHERE... 3 years ago
SELECT page_namespace, page_title, page_len FROM page WHERE page_len >... 3 years ago
SELECT page_is_redirect, page_title, user_name, ... 3 years ago
SELECT page_is_redirect, page_title, user_name, logs.log_timestamp, ... 3 years ago
USE idwiki_p; SELECT DISTINCT CONCAT('# [[:File:', p.page_title, ']]') FROM... 3 years ago
USE idwiki_p; SELECT concat('* [[File talk:', p.page_title, ']] ') as... 3 years ago
USE idwiki_p; SELECT concat('* [[File talk:', p.page_title, ']] ') as... 3 years ago
use mswiki_p; select img_name from image where img_name not like '%.jpg'... 3 years ago
use enwiki_p; select img_name from image where img_name not like '%.jpg'... 3 years ago
use mswiki_p; select img_name from image where img_name not like '%.jpg'... 3 years ago
use jvwiki_p; select img_name from image where img_name not like '%.jpg'... 3 years ago
USE idwiki_p; SELECT SUM(IF(up_value = "male", 1, 0)) as... 3 years ago
USE idwiki_p; SELECT CONCAT('[[{{ns:', page_namespace, '}}:', page_title,... 3 years ago
USE idwiki_p; SELECT CONCAT('[[{{ns:', page_namespace, '}}:', page_title,... 3 years ago
USE idwiki_p; SELECT CONCAT('[[{{ns:', page_namespace, '}}:', page_title,... 3 years ago