get_user_mobile

gistfile1.txt

SELECT users.mobile FROM users
WHERE users.mobile NOT IN (
    SELECT users.mobile FROM subscriptions
    INNER JOIN users ON subscriptions.user_id = users.id
    WHERE subscriptions.type IN (1,2) AND
    subscriptions.status = 2 AND
    users.mobile IS NOT NULL
);