Untitled query #87974

SQL

SELECT 
CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', pu.user_name) AS 'User',
TIMESTAMP(pu.registered) AS 'Registered',
CASE WHEN p.page_id IN (SELECT cl_from FROM tp_cats) THEN 'Yes' ELSE 'No' END AS 'Warned',
ec.edit_count AS 'Edit count',
TIMESTAMP(ec.last_edit) AS 'Last edit',
fc.filter_count AS 'Filter trip count',
TIMESTAMP(fc.last_filter) AS 'Last filter trip'
FROM promo_users pu
INNER JOIN edit_count ec ON pu.user_id = ec.user_id
INNER JOIN filter_count fc ON pu.user_id = fc.user_id
LEFT JOIN page p ON pu.user_name = REPLACE(p.page_title, '_', ' ') AND p.page_namespace = 3
WHERE ec.edit_count <= 30
AND (ec.last_edit > DATE_SUB(NOW(), INTERVAL 3 DAY) OR fc.last_filter > DATE_SUB(NOW(), INTERVAL 3 DAY))
SQL

Checking query status...
