UPDATE shop_user
INNER JOIN forum f ON(f.id_user=shop_user.user_id)
SET shop_user.flags=shop_user.flags | 2
shop_user.make_date=shop_user.make_date
WHERE shop_user.flags NOT LIKE '%comments%'
AND f.type_mess='forum'
AND f.report_type=''
AND f.type='film'
AND shop_user.status='ok'
AND shop_user.user_id!=1