SELECT * FROM subgrupoart WHERE cod_grupoart = '00005'AND COD_SUBGRUPO like '090%' 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 '090%'
27
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|09001'
RADIADORES DE ALUMINO

RADIADORES DE ALUMINO

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '090%'
27
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|09002'
RADIADOR SECATOALLAS

RADIADOR SECATOALLAS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '090%'
27
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|09005'
RADIADORES ELECTRICOS

RADIADORES ELECTRICOS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '090%'
27
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|09006'
RADIADORES BAJA TEMPERATURA

RADIADORES BAJA TEMPERATURA

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '090%'
27
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|09009'
ACC. Y SOPORTES DE RADIADOR

ACC. Y SOPORTES DE RADIADOR