| SELECT
COUNT(*),
TRIM(LEADING 'www.' FROM... |
2 years ago |
| SELECT
ipb_address,
ipb_by_actor,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
ipb_address,
ipb_by_actor,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
ipb_address,
ipb_by_actor,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
ipb_address,
ipb_by_actor,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
ipb_address,
ipb_by_actor,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
ipb_address,
ipb_by_actor,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
ipb_address,
ipb_by_text,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
0 - DATEDIFF(NOW(),... |
2 years ago |
| SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
0 - DATEDIFF(NOW(),... |
2 years ago |
| SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
0 - DATEDIFF(NOW(),... |
2 years ago |
| SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
0 - DATEDIFF(NOW(),... |
2 years ago |
| SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
0 - DATEDIFF(NOW(),... |
2 years ago |
| SHOW INDEX IN ipblocks; |
2 years ago |
| SELECT * FROM ipblocks;
LIMIT 10; |
2 years ago |
| DESCRIBE ipblocks; |
2 years ago |
| DESCRIBE ip_changes; |
2 years ago |
| select actor_name from actor_recentchanges; |
2 years ago |
| DESCRIBE actor_recentchanges; |
2 years ago |
| DESCRIBE flaggedrevs_stats; |
2 years ago |
| DESCRIBE page; |
2 years ago |
| SELECT * FROM flaggedrevs_statistics; |
2 years ago |
| SHOW TABLES; |
2 years ago |
| DESCRIBE idwiki_p; |
2 years ago |
| DESCRIBE externallinks; |
2 years ago |
| SELECT
img_name
FROM image
WHERE NOT EXISTS (SELECT
... |
2 years ago |
| SELECT
img_name
FROM image
WHERE NOT EXISTS (SELECT
... |
2 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
| SELECT
actor_name,
log_namespace,
log_timestamp,
log_action,
... |
2 years ago |
| SELECT COUNT(DISTINCT rd_from)
FROM redirect
INNER JOIN page ON... |
2 years ago |
| SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
FROM ipblocks
WHERE... |
2 years ago |
| SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
ipb_reason
FROM... |
2 years ago |
| SELECT
ipb_address,
ipb_by_text,
ipb_timestamp,
ipb_expiry,
... |
2 years ago |
| SELECT
comment_text,
COUNT(log_id) AS uses
FROM logging
JOIN `comment`... |
2 years ago |
| SELECT
page_namespace,
page_title,
page_len
FROM page
LEFT JOIN... |
2 years ago |
| SELECT
p1.page_namespace,
p1.page_title
FROM page AS p1
WHERE... |
2 years ago |
| SELECT
page_namespace,
MAX(notredir),
MAX(redir)
FROM (
SELECT... |
2 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
| SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE... |
2 years ago |
| SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE page_len >... |
2 years ago |
| SELECT
page_is_redirect,
page_title,
user_name,
... |
2 years ago |
| SELECT
page_is_redirect,
page_title,
user_name,
logs.log_timestamp,
... |
2 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 |
