SELECT * FROM subgrupoart WHERE cod_grupoart = '00005'AND COD_SUBGRUPO like '%00' AND `COD_GRUPOART` in (select grupo from articulos where `MARCA`='00600') AND concat(`cod_grupoart`,left(`COD_SUBGRUPO`,2)) in (select concat(`grupo`,left(subgrupo,2)) from articulos where `MARCA`='00600' )
SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '010%'
15
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|01000'
TERMOS ELECTRICOS Y ACC.

TERMOS ELECTRICOS Y ACC.

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '020%'
2
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|02000'
CALENTADORES A GAS

CALENTADORES A GAS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '030%'
3
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|03000'
CALDERAS

CALDERAS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '050%'
1
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|05000'
CHIMENEAS CONDUCTOS  Y ACC. EVACUACION HUMOS

CHIMENEAS CONDUCTOS Y ACC. EVACUACION HUMOS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '060%'
7
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|06000'
BOMBAS Y GRUPOS HIDRAULICOS

BOMBAS Y GRUPOS HIDRAULICOS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '080%'
15
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|08000'
DEPOSITOS ACS, ACUMULADORES E INTERACUMULADORES

DEPOSITOS ACS, ACUMULADORES E INTERACUMULADORES

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|09000'
EMISORES

EMISORES

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '100%'
1
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|10000'
AISLAMIENTO TUBERIA

AISLAMIENTO TUBERIA

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|11000'
VALVULERIA, REGULACIÓN Y CONTROL

VALVULERIA, REGULACIÓN Y CONTROL

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '120%'
9
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|12000'
SUELO RADIANTE

SUELO RADIANTE

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00005' AND subgrupo like '130%'
20
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00005|13000'
CALDERAS Y GRUPOS TERMICOS DE GASOIL

CALDERAS Y GRUPOS TERMICOS DE GASOIL