PROBLEMA PARA UNA NEGACION <> o LIKE NOT

[fmb1982]

Trato omitir donde el campo Status indique que esta cancelado, y hace todo lo contrario me trae de regreso donde encuentra la palabra 'Cancelado' sl2.:??

Código MySQL:

SELECT rfc_s, nom_s, ape1_s, ape2_s, monto, tpago from (
(SELECT rfc_s, nom_s, ape1_s, ape2_s, mon_pg as monto, cpc_conc.`status` as tpago from soc_per, cuo_pag, cpc_conc WHERE rfc_s like rfc_soc and id_r like id_transaccion) 
UNION 
(SELECT rfc_s, nom_s, ape1_s, ape2_s, mon_pg as monto, tip_pg  as tpago from soc_per, cuo_pag_vn, cpc_conc WHERE rfc_s like cuo_pag_vn.rfc_soc)) as tabla where tpago != '%Cancelado%'