/*запрос для выборки (если захочешь проверить)*/
SELECT DISTINCT su.user_id
FROM forum f
INNER JOIN shop_user su ON(f.id_user=su.user_id)
WHERE su.flags NOT LIKE '%comments%'
AND f.type_mess='forum'
AND f.report_type=''
AND f.type='film'
AND su.status='ok'
AND su.user_id!=1
/*запрос для изменения*/
UPDATE shop_user
INNER JOIN forum f ON(f.id_user=shop_user.user_id)
SET shop_user.flags=CONCAT(shop_user.flags,',comments'),
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.status='ok'
AND shop_user.user_id!=1