UPDATE shop_user INNER JOIN forum ON id_user shop_user user_id SET sho

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
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