Untitled query #88564

SQL

SET @time_interval = 6;  # заблокированные ранее указанного количества месяцев назад
# проверять на предмет переблокировки, при изменении параметров блока остаётся старая дата

SELECT user_name AS name, GROUP_CONCAT(ug_group SEPARATOR ", ") AS flag, bl_timestamp AS time, comment_text AS reason FROM user_groups
JOIN user ON ug_user = user_id
JOIN block_target ON user_id = bt_user
JOIN block ON bt_id = bl_target
JOIN comment ON bl_reason_id = comment_id
WHERE ug_group in ("extendedconfirmed")
AND bl_expiry = "infinity"
AND bl_timestamp <= DATE_SUB(now(), INTERVAL @time_interval MONTH)
AND bl_sitewide = 1
GROUP BY name
ORDER BY name
SQL

Checking query status...
