Untitled query #62285

SQL

SELECT
  comment_text,
  COUNT(*)
FROM ipblocks
JOIN comment_ipblocks
  ON ipb_reason_id = comment_id
WHERE
  ipb_user = 0
  AND ipb_auto = 0
  AND ipb_sitewide = 1
  AND ipb_expiry NOT IN (
    'infinity',
    'indefinite'
  )
  AND DATEDIFF(
    NOW(),
    STR_TO_DATE(LEFT(ipb_timestamp, 8), '%Y%m%d')
  ) BETWEEN 8 AND 1500
  AND DATEDIFF(
    STR_TO_DATE(LEFT(ipb_expiry, 8), '%Y%m%d'),
    STR_TO_DATE(LEFT(ipb_timestamp, 8), '%Y%m%d')
  ) > 90
  AND comment_text NOT LIKE '%m:NOP%'
  AND comment_text NOT LIKE '%[[NOP%'
  AND comment_text NOT LIKE '%[[w:Open proxy%'
  AND comment_text NOT LIKE '%hosting%'
GROUP BY comment_text
ORDER BY COUNT(*) DESC
SQL

Checking query status...
