PLATO DE DUCHA - SLATE

SELECT DISTINCT SUBSTRING_INDEX(ucase(`ESPECIF_1`), 'X', 1) AS `alto` FROM articulos WHERE grupo = '00006' AND subgrupo= '02002' AND `MODELO` in (SELECT `MODELO` FROM articulos WHERE COD_ARTICULO = '6001000187') AND `MODELO` NOT LIKE '' ORDER BY `alto`

SELECT DISTINCT left(SUBSTRING_INDEX(ucase(`ESPECIF_1`), 'X', -1),3) AS `ancho` FROM articulos WHERE grupo = '00006' AND subgrupo= '02002' AND `MODELO` in (SELECT `MODELO` FROM articulos WHERE COD_ARTICULO = '6001000187') AND `MODELO` NOT LIKE '' ORDER BY `ancho`