| use fawiki_p;
SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
0 -... |
5 years ago |
| use fawiki_p;
SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
0 -... |
5 years ago |
| use fawiki_p;
SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
... |
5 years ago |
| use fawiki_p;
SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
... |
5 years ago |
| use fawiki_p;
SELECT
ipb_address,
ipb_timestamp,
ipb_expiry,
... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT ipb_timestamp, ipb_expiry, DATEDIFF(NOW(),... |
5 years ago |
| use fawiki_p;
SELECT ipb_timestamp, ipb_expiry, DATEDIFF(NOW(),... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT STR_TO_DATE(LEFT(ipb_expiry, 8), '%Y%m%d')
FROM... |
5 years ago |
| use fawiki_p;
SELECT STR_TO_DATE(LEFT(ipb_expiry, 8), '%Y%m%d'), *
FROM... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user = 0
AND ipb_expiry... |
5 years ago |
| use fawiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_parent_block_id IS NULL
... |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_parent_block_id IS NULL
... |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_parent_block_id IS NULL
... |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_expiry NOT IN (
... |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblocks
WHERE
ipb_user
ipb_expiry NOT IN (
... |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblocks
WHERE ipb_expiry NOT IN (
... |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblocks
LIMIT 100 |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblocks |
5 years ago |
| use frwiki_p;
SELECT *
FROM ipblock |
5 years ago |
| use frwiki_p;
select
page_len_category,
count(*) as freq
from (
... |
5 years ago |
| use information_schema;
SELECT * FROM statistics; |
6 years ago |
| USE fawiki_p;
SELECT DISTINCT
TABLE_NAME,
INDEX_NAME
FROM... |
6 years ago |
| USE fawiki_p;
show index from revision; |
6 years ago |
| USE fawiki_p;
SELECT revision.rev_user_text, count(revision.rev_id) as edits... |
8 years ago |
| USE fawiki_p;
SELECT revision.rev_user_text, count(revision.rev_id) as edits... |
8 years ago |
| USE fawiki_p;
SELECT revision.rev_user_text, count(revision.rev_id) as edits... |
8 years ago |
| USE fawiki_p;
SELECT revision.rev_user_text, count(revision.rev_id) as edits... |
8 years ago |
| USE fawiki_p;
SELECT revision.rev_user_text, count(revision.rev_id) as edits... |
8 years ago |
