"Receive Email from Administrators": Which members have set this to "no"?

[kh99]

You'd need something like:

UPDATE user LEFT JOIN userfield USING(userid) 
   SET fieldX='No', fieldY='No', fieldZ='No' 
   WHERE (options & 16) = 0

and

UPDATE user LEFT JOIN userfield USING(userid) 
   SET fieldY='No' 
   WHERE (options & 4096) = 0

of course you need to set X, Y, and Z to the actual ids.