Untitled query #89185

SQL

SELECT
	bt_address,
    actor_block.actor_name AS blocking_admin,
    DATE_FORMAT(bl_timestamp, '%Y-%m-%d %H:%i') AS block_time,
    comment_text AS block_reason
FROM block
INNER JOIN block_target ON bl_target = bt_id
INNER JOIN comment_block ON bl_reason_id = comment_id
INNER JOIN actor_block ON bl_by_actor = actor_id
WHERE bl_expiry != "infinity"
AND   bl_expiry > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL 2 YEAR), '%Y%m%d%H%i%s')
AND   bt_auto = 0
AND   bt_address IS NOT NULL
AND   comment_text NOT RLIKE ".*(proxies|proxy|checkuser).*";
SQL

Checking query status...
