DELETE FROM phplist_listuser

DELETE FROM phplist_listuser
WHERE listid = 38
AND userid IN (
SELECT userid
FROM (
SELECT userid
FROM phplist_listuser
WHERE listid = 31
) AS paypal_users
);