Luna
Marble, a splendid material provided by nature, inspires this collection with which you will put literally the moon at your feet. Make your dreams come true and place the universe inside your home with the new collection Luna: delightful from any part of the world and a symbol of everlasting and universal beauty.
SELECT s.id id, s.nom nom, f.nom_cm formato, s.subtipomaterial subid, sm.subtipo_en 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 s.id IN (SELECT MIN(s.id) id FROM vives_db.series s LEFT JOIN vives_db.colecciones c ON c.id = s.coleccion WHERE 1 = 1 AND s.coleccion != 0 AND c.visible = 1 AND s.vigente = 1 AND c.id = 35 GROUP BY nom) ORDER BY s.nom; ;