Ventilador Fan cooler NMB-MAT 3110RL-04W-S59 Projector Cooling Fan ViewSonic PJD6221 and many others

ARS 374.61

{{ GBP_LIST; NAME:=stockb; SQLSCRIPT:= select tpli.semaphoreValue FROM tbitem ti INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN vwWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = {(GBP_PRICELIST)} INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id LEFT JOIN tbWebSiteII_TMPItem4Compare i4c ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}' LEFT JOIN tbWebSiteII_Items_Favorites ifav ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}' AND ifav.wsif_isActive ='true' INNER JOIN vwWebSiteII_ItemsStock tmp2 on tmp2.comp_id = ti.comp_id AND tmp2.item_id = ti.item_id AND tmp2.stor_id= {(GBP_STORAGE)} Where ti.item_id = 1294 AND tpli.ws_id = '{(GBP_WSID)}'; SQLFIELDS4REPLACE:=§STOCK§; ITEMSBYPAGE:=8; TEMPLATEPAGE:=STOCKLI; }}