Stuff

SELECT user_id, user_name, COUNT(*) AS actions_count FROM users_action JOIN users ON users_action.user_id = users.id WHERE users.role = 1 AND type_id = 0 AND mt_id IN (SELECT id FROM main_table WHERE status = 1 AND added_date > CURDATE()) GROUP BY user_id