Product Information
Product Specifications
|
|
|
PageComponents_ProductDetail_SimilarItemsPanel
select top 2 i.ItemID, 'http://www.bocabearings.com/ShowImage.aspx?w=150&folder=products&img=' + i.ImageFile as ImagePath, i.WebPartNumber as SKU, Convert(decimal(8,2),i.SellPrice$2) as Price, ie.CategoryValues$3 as DimensionType, ie.CategorySet, ie.CategoryValues$4 as ID, ie.CategoryValues$5 as OD, ie.CategoryValues$6 as WD from Item i left join ItemExtension ie on ie.ItemID=i.ItemID where ie.CategorySet = 1 and ie.CategoryValues$4 = '17' and ie.CategoryValues$5 = '26' and ie.CategoryValues$6 = '5' and ie.CategoryValues$23 = 'item' and ie.CategoryValues$3 = 'Metric' and i.ItemID <> 9116 and i.ItemID in (select i.ItemID from item i left join ItemExtension ie on ie.itemid=i.itemid left join ProductGroup pg on pg.CategorySet=ie.CategorySet where (pg.DealerProduct is null or pg.DealerProduct <> 1) ) order by i.SellPrice$2
Thank you!
Team at Boca Bearing,
This email is to expess or thanks for you great service last week.
With your help we have keep critical equipment operational here at
Kennametal.
I look forward to working with you on current and future needs.
Thanks!
MORE »
|
|