SELECT * FROM subgrupoart WHERE cod_grupoart = '00005'AND COD_SUBGRUPO like '110%' AND `COD_GRUPOART` in (select grupo from articulos where `MARCA`='00600') AND `COD_SUBGRUPO` in (select subgrupo from articulos where `MARCA`='00600') AND `COD_SUBGRUPO` in (select subgrupo from articulos where `GRUPO`='00005')
SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '110%'
11
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|11003'
TERMOSTATOS Y CRONOTERMOSTATOS

TERMOSTATOS Y CRONOTERMOSTATOS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '110%'
11
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|11007'
CABEZALES

CABEZALES

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '110%'
11
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|11008'
VALVULAS RADIADOR

VALVULAS RADIADOR

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '110%'
11
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|11009'
DETENTORES

DETENTORES

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '110%'
11
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|11013'
VÁLVULA ZONA

VÁLVULA ZONA

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '110%'
11
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|11016'
SEPARADORES HIDRAULICOS

SEPARADORES HIDRAULICOS