SELECT a.matnr AS matnr, a.titulo AS titulo, a.sinopsis AS sinopsis, b.cod_autor AS cod_autor, b.autor AS autor, c.sello_editorial AS sello_editorial, a.fecha_nov AS fecha_nov, a.manuscrito_grupo, a.imagen_matnr AS imagen_matnr, a.region AS region, "libros" AS tipo_material_virtual, d.destacado AS destacado, a.fragmentos AS fragmentos, d.orden AS orden FROM libros AS a INNER JOIN autores_detalle AS b ON a.cod_autor = b.cod_autor INNER JOIN sellos AS c ON a.cod_sello_editorial = c.cod_sello_editorial INNER JOIN promo_destacados AS d ON a.matnr = d.matnr WHERE a.eliminado = 'N' AND a.bloqueado = 'N' AND a.publica = 'S' AND d.id_promocion = 24 ORDER BY d.orden ASC LIMIT 100

SELECT DISTINCT a.matnr AS matnr, a.titulo AS titulo, a.sinopsis AS sinopsis, b.cod_autor AS cod_autor, b.autor AS autor, c.sello_editorial AS sello_editorial, a.fecha_nov AS fecha_nov, a.manuscrito_grupo, a.imagen_matnr AS imagen_matnr, a.region AS region, "libros" AS tipo_material_virtual, a.fragmentos AS fragmentos FROM libros AS a INNER JOIN adm_rango_promo AS z ON a.cod_sector = z.cod_sector and z.id_promocion=24 INNER JOIN adm_sellos_promo AS w ON a.cod_sello_editorial = w.cod_sello_editorial and w.id_promocion=24 INNER JOIN adm_formatos_promo AS f ON ( a.cod_tipo_edicion = f.cod_tipo_edicion or a.cod_tipo_material= f.cod_tipo_edicion ) and f.id_promocion=24 INNER JOIN libros_bisac AS d ON a.matnr = d.matnr INNER JOIN adm_bic_promo AS x ON d.zzbisac = x.cod_bisac and x.id_promocion=24 INNER JOIN autores_detalle AS b ON a.cod_autor = b.cod_autor INNER JOIN sellos AS c ON a.cod_sello_editorial = c.cod_sello_editorial WHERE a.eliminado = 'N' AND a.bloqueado = 'N' AND a.publica = 'S' group by a.manuscrito_grupo ORDER BY a.region = "MX" DESC, a.fecha_nov desc LIMIT 100