SELECT id FROM cd_propiedades
WHERE id='72'
AND (habilitar=0 OR contrato>=NOW() OR contrato_fin < NOW()
OR
(SELECT COUNT(*) FROM cd_pagos WHERE (habilitar=1 OR pago=0) AND propiedad=cd_propiedades.id AND vigencia_ini<=CURDATE() AND vigencia_fin>=CURDATE())=0)
|