SELECT COUNT(*) AS users
                FROM user AS user
                LEFT JOIN userfield AS userfield USING (userid)

                WHERE 1=1 AND field5 LIKE '%MuDvAyNe%'
                        AND     user.usergroupid IN (-1,6,19,7,15,2,10,5);