[Scott MacVicar]

did you return the Query to,

PHP Code:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE $condition AND user.userid = userfield.userid
                                ".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
                          ORDER BY $orderby $direction
                          LIMIT ".($limitlower-1).",$perpage");