Recent long-term IP blocks on enwiki

SQL

USE enwiki_p;
SELECT
  ipb_address,
  ipb_timestamp,
  ipb_expiry,
  DATEDIFF(
    STR_TO_DATE(LEFT(ipb_expiry, 8), '%Y%m%d'),
    STR_TO_DATE(LEFT(ipb_timestamp, 8), '%Y%m%d')
  ) AS duration,
  ipb_reason_id,
  comment_text
FROM ipblocks
JOIN comment
  ON ipb_reason_id = comment_id
WHERE
  ipb_user = 0
  AND ipb_auto = 0
  AND ipb_expiry NOT IN (
    'infinity',
    'indefinite'
  )
  AND DATEDIFF(NOW(), STR_TO_DATE(LEFT(ipb_timestamp, 8), '%Y%m%d')) < 14
  AND DATEDIFF(
    STR_TO_DATE(LEFT(ipb_expiry, 8), '%Y%m%d'),
    STR_TO_DATE(LEFT(ipb_timestamp, 8), '%Y%m%d')
  ) > 180
  AND comment_text LIKE '%proxy%'
ORDER BY ipb_id DESC
SQL

Checking query status...
