SELECT ntnotcnot, ntnotfein, ntnotante, ntnottitu, ntnotturl, ntnottext, ntnotcsec, ntsecimpo, ntnotimpo, ntsecnomb, ntsecnpag, ntfovenla, ntfovdpie FROM ntnot INNER JOIN ntsec ON ntseccsec=ntnotcsec LEFT JOIN ntfov ON ntnotcnot=ntfovcnot AND ntfovimpo=1 AND ntnotfein=ntfovfein AND ntfovesta=1 AND ntfovtipo!='E' WHERE ntnotfein='2017-12-31' AND ntnotcsec=4 AND ntnotesta=1 AND ntnotulth!=1 ORDER BY ntnotimpo DESC;SENTIMOS LAS MOLESTIAS EN BREVE SOLUCIONAREMOS EL PROBLEMA.