select RAXA.id,CFGA.id as idarticulo,CFGA.codigoarticulo as codigoart,CFGA.familia as fam,CFGA.descripcion as descrip,CFGA.subfamilia as subfamilia,A2.descripcion as almacen,RAXA.ctopromedio as premecos,(RAXA.existotal-RAXA.exispedidos-RAXA.exisproceso) as stock,CFGA.marca as ADIC1,PA.pvp1  as ADIC2,PA.pvp2 as ADIC3,PA.pvp3 as ADIC4,PA.pvp4 as ADIC5,PA.pvp5 as ADIC6,PA.pvp6 as ADIC7,PA.pvp7 as ADIC8,PA.pvp8 as ADIC9,PA.pvp9 as ADIC10,CFGA.pvp2 as subfam2,CFGA.pvp3 as subfam3,CFGA.pvp4 as subfam4,CFGA.pvp5 as subfam5,CFGA.pvp6 as subfam6,CFGA.pvp7 as subfam7,CFGA.pvp8 as subfam8 from (cfg_articulos CFGA inner join ref_artxalmacen RAXA on CFGA.id=RAXA.fk1mcfg_articulos inner join cfg_almacenes A2 on A2.id=RAXA.fk1mcfg_almacenes inner join cfg_preciosxalmacenes PA on (PA.fk1mcfg_articulos=CFGA.id and PA.fk1mcfg_almacenes=RAXA.fk1mcfg_almacenes)) where 1=1 and CFGA.familia like 'LLANTA%' and CFGA.itemservicio='' order by CFGA.familia,CFGA.subfamilia,CFGA.codigoarticulo