SELECT * FROM subgrupoart WHERE cod_grupoart = '00003'AND COD_SUBGRUPO like '010%' 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`='00003')
SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00003' AND subgrupo like '010%'
14
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00003|01001'
CONJUNTO SPLIT

CONJUNTO SPLIT

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00003' AND subgrupo like '010%'
14
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00003|01002'
CONJUNTO MULTISPLIT

CONJUNTO MULTISPLIT

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00003' AND subgrupo like '010%'
14
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00003|01003'
CONJUNTO CONDUCTOS

CONJUNTO CONDUCTOS

SELECT DISTINCT modelo FROM articulos WHERE `MARCA`='00600' AND grupo = '00003' AND subgrupo like '010%'
14
SELECT * FROM imagenes WHERE NUM_FOTO='02' AND tabla = 'SUBGRUPOART' AND clave = '00003|01004'
CASSETTE

CASSETTE