SELECT ntnotcnot, ntnotante, ntnottitu, ntnotturl, ntnottext, ntnotcaut, ntnotcsec, ntnotcavi, ntsecnomb, ntsecnpag, ntfovenla, ntfovdpie, ntautnomb, ntautapat, ntautenla FROM ntnot INNER JOIN ntsec ON ntseccsec=ntnotcsec LEFT JOIN ntfov ON ntnotcnot=ntfovcnot AND ntnotfein=ntfovfein AND ntfovesta=1 AND ntfovimpo=1 AND ntfovtipo!='E' LEFT JOIN ntaut ON ntnotcaut=ntautcaut WHERE (ntnotcsec<=20 OR ntnotcsec BETWEEN 41 AND 50) AND ntnotfein='2015-01-01' AND ntnotesta=1 AND ntnotulth!=1 ORDER BY ntsecimpo ASC, ntnotimpo DESC, ntnotfech ASC LIMIT 200;SENTIMOS LAS MOLESTIAS EN BREVE SOLUCIONAREMOS EL PROBLEMA.