Product Information
Product Specifications
One Way Clutch Bearings Tools
One Way Clutch Bearings Lube
|
|
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 = 5 and ie.CategoryValues$4 = '10' and ie.CategoryValues$5 = '14' and ie.CategoryValues$6 = '12' and ie.CategoryValues$23 = 'item' and ie.CategoryValues$3 = 'Metric' and i.ItemID <> 2983 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
|
|