Model = MOD_MTC

path = /img/prd/RUOTE/gallery/MOD_MTC/17/

SQL=select x.*,pl.free1,pl.free2 from [dbo].[nccat4_xcattab_ruote] x inner join nccat4_product p on p.code=x.code inner join nccat4_product_lang pl on pl.prd=p.code where x.idparent='SE5252000031' AND pl.lang='it' AND p.free1='cm0750270010-5' ORDER BY A1,A2,A3

SQL_0=select x.*,gl.title,r.kit,r.applicazioni,r.colori,dbo.[nodecomm_productprice](x.code,'') as price,p.discountprice,p.free2 as ref_prd,p.fam,g.mod,g.cat from [dbo].[nccat4_xcattab_ruote] x inner join [dbo].[nccat4_Product] p on p.code=x.code inner join [dbo].[nccat4_xcattab_global] g on g.code=x.code inner join [dbo].[nccat4_xcattab_global_it] gl on gl.code=x.code left outer join nccat4_xcattab_ruote_calc r on r.code=x.code where p.type=0 and x.id=6047

prd_fam=RUOTE prd_mod=MOD_MTC prd_diam=17 a1= a2= a3= a4= a5=MOD_MTC a6=17

ASTDiametro 17.000000

ASTLarghezza 8.000000

ASTET 25.000000

ASTN° fori 5.000000

ASTPCD 98.000000

ASTCap SI

ASTCenter Bore 58.100000

ASTBoccola SI

ASTFissaggio 60°

ASTAn. centraggio NO

ASTMarca Lancia

ASTModello Delta HF Integrale 16V

ASTImpiegor Stradale

ASTColore Silver

ASTPeso_Eff 11.700000

ASTPeso_Imb 13.600000

ASTNote_ruote cap Lancia OE

MOD MOD_MTC