Product Information
Product Specifications
Dental Tool Bearings Tools
Dental Tool 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 = 23 and ie.CategoryValues$4 = '0.1250' and ie.CategoryValues$5 = '0.2500' and ie.CategoryValues$6 = '0.1090' and ie.CategoryValues$23 = 'item' and ie.CategoryValues$3 = 'Inch' and i.ItemID <> 2531 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
Currently there is no feedback for this product.
Please click the back button to return to the product listing.
|
|