Gres porcelánico y revestimiento cerámico imitación mármoles
Revestimiento y gres porcelánico imitación mármol
SELECT s.id id, s.nom nom, f.nom_cm formato, s.tipomaterial tipid, s.subtipomaterial subid, tm.tipomaterial_es tipnom, sm.subtipo_es subnom, LOWER(t.nom_es) tipol FROM vives_db.series s LEFT JOIN vives_db.serie_has_tipologia AS st ON st.id_serie = s.id LEFT JOIN vives_db.tipologia AS t ON st.id_tipologia = t.idtipologia LEFT JOIN vives_db.formatos f ON f.id = s.formato LEFT JOIN vives_db.subtipomaterial sm ON sm.idsubtipomaterial = s.subtipomaterial LEFT JOIN vives_db.tipomaterial tm ON s.tipomaterial = tm.idtipomaterial WHERE 1 = 1 AND s.id IN (SELECT MIN(s.id) id FROM vives_db.series s LEFT JOIN vives_db.serie_has_tipologia AS st ON st.id_serie = s.id WHERE 1 = 1 AND s.vigente = 1 AND st.id_tipologia = 4 GROUP BY nom ORDER BY s.nom) ORDER BY id desc;
Array ( [0] => Array ( [id] => 828 [nom] => LUNA [formato] => 119,3X119,3 [tipid] => 3 [subid] => 3 [tipnom] => pavimento [subnom] => gres porcelánico [tipol] => mármoles ) [1] => Array ( [id] => 781 [nom] => MARBLELOUS [formato] => 79,3X179,3 [tipid] => 3 [subid] => 3 [tipnom] => pavimento [subnom] => gres porcelánico [tipol] => mármoles ) [2] => Array ( [id] => 733 [nom] => NIKOI [formato] => 120X120 [tipid] => 3 [subid] => 3 [tipnom] => pavimento [subnom] => gres porcelánico [tipol] => mármoles ) [3] => Array ( [id] => 706 [nom] => LESOLO [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => revestimiento [subnom] => pasta blanca [tipol] => mármoles ) [4] => Array ( [id] => 702 [nom] => DONEY [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => pavimento [subnom] => gres porcelánico [tipol] => mármoles ) [5] => Array ( [id] => 622 [nom] => WILSON [formato] => 10X20 [tipid] => 2 [subid] => 5 [tipnom] => revestimiento [subnom] => pasta roja [tipol] => mármoles ) [6] => Array ( [id] => 615 [nom] => DANDY [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => revestimiento [subnom] => pasta blanca [tipol] => mármoles ) [7] => Array ( [id] => 524 [nom] => TITÁN [formato] => 59,3X59,3 [tipid] => 3 [subid] => 4 [tipnom] => pavimento [subnom] => pasta porcelánica [tipol] => mármoles ) )