update `dle_users` AS uu
SET uu.user_group=6
WHERE uu.user_id in(
SELECT user_id FROM ( SELECT u.user_id
FROM `dle_users` AS u, ibf_members AS m
WHERE u.news_num =0
AND u.comm_num =0
AND m.posts =0
AND m.name = u.name
) AS T
)