UPDATE shop_user INNER JOIN forum ON id_user shop_user user_id SET sho

  • Anonymous
  • SQL
  • 15 Oct 2009 
 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
← newer dump
older dump →