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 |