---

SELECT nv.id, nv.antetitulo, nv.titulo, nv.intro, nv.autor, nv.data_presentacion , en.pequena, en.url as imaxe, en.titulo as alt, IF(en.pequena = "1", en.copia_ancho, en.ancho) as ancho , IF(en.pequena = "1", en.copia_alto, en.alto) as alto,rex.id_usuario FROM (novas AS nv , edicions AS ed) LEFT JOIN enlaces AS en ON (en.id_rexistro = nv.id AND en.taboa = "novas" AND en.tipo = "imx" AND en.id_clase = "15" AND en.orde = "2") LEFT JOIN xrexistros as rex ON (rex.taboa = "novas" and rex.accion = "crear" AND rex.id_rexistro = nv.id) WHERE nv.id_edicion = "63" AND nv.portada = "1" AND nv.id_clase = "9" AND nv.estado = "1" AND ed.id = nv.id_edicion AND ((nv.data_inicio = 0) || (nv.data_inicio <= 1265741964)) AND ((nv.data_fin = 0) || (nv.data_fin >= 1265741964)) and nv.id > ((select max(id) from novas) - 5000) GROUP BY nv.id ORDER BY nv.orde ASC, nv.data_presentacion DESC limit 0,20;

---

---