/* Caso 1 - Obtener Ids nuevos clientes */
SELECT idclientecrm
FROM srv_clientes cli
WHERE cli.disabled = 0
AND cli.idclientecrm NOT IN (
    SELECT
CAST(acc.public_id AS INT)
AS idclientecrm
FROM TVCM_ACCOUNT acc
    );

/* Caso 6 - Obtener Ids eliminados */
SELECT acc.idclientecrm FROM (
    SELECT CAST(public_id AS INT) AS idclientecrm
    FROM TVCM_ACCOUNT
) acc
WHERE acc.idclientecrm NOT IN (
    SELECT idclientecrm
    FROM srv_clientes cli
    WHERE cli.disabled = 0
);


/* Caso 2 - Nuevos dispositivos */
SELECT * FROM srv_stb
WHERE stbid NOT IN (
    SELECT original_id FROM TVCM_TARGET
)

/* Caso 7 - Dispositivo dado de baja */
SELECT * FROM TVCM_TARGET
WHERE original_id NOT IN (
    SELECT stbid FROM srv_stb WHERE smartcard IS NOT NULL
    )