SELECT * FROM USERS
WHERE
  (user_group="allow" OR user_group="admin")
  AND
  (user_subscription="autogoal" OR user_subscription="all")