Usuarios establecidos con nivel de confianza bloqueado en 0 o 1:
-- [parámetros]
-- int :min_días_visitados = 30
-- int :min_publicaciones = 1
SELECT
id AS user_id,
manual_locked_trust_level,
days_visited,
post_count
FROM
users u JOIN
user_stats us ON u.id = us.user_id
WHERE
manual_locked_trust_level IN (0,1) AND
days_visited >= :min_días_visitados AND
post_count >= :min_publicaciones AND
(silenced_till IS NULL OR silenced_till < NOW()) AND
(suspended_till IS NULL OR suspended_till < NOW())
ORDER BY
days_visited DESC