Colección Basic

SELECT MIN(s.id) id, s.nom nom, MIN(f.nom_cm) formato, MIN(s.subtipomaterial) subid, MIN(sm.subtipo_es) subnom FROM vives_db.series s LEFT JOIN vives_db.colecciones c ON c.id = s.coleccion LEFT JOIN vives_db.formatos f ON f.id = s.formato LEFT JOIN vives_db.subtipomaterial sm ON sm.idsubtipomaterial = s.subtipomaterial WHERE 1 = 1 AND s.coleccion != 0 AND c.visible = 1 AND s.vigente = 1 AND c.id = 17 GROUP BY nom ORDER BY s.nom ;