SELECT
userID,
userEmail,
userNewsletter,
userSMSRefill


FROM
    users

WHERE userID IN (

            SELECT
             userID
            FROM
                alertcontacts

            WHERE
                alertContactType IN (8,14)
                AND alertContactStatus = 2

            GROUP BY
                    userID
            ORDER BY
                userID)
    AND (userSMSRefill = 0  OR userSMSRefill IS NULL)

ORDER BY
    userNewsletter,
    userSMSRefill