Product Information
Product Specifications
PageComponents/ProductDetail/CommonApplicationsPanel
SELECT distinct ProductGroup.ProductGroupName as prompt, 'search.aspx?ComponentItemID=4432&ProductGroupID=' + Convert(varchar,ProductGroup.ProductGroupID) as href FROM KitComponents INNER JOIN ProductSubgroupItems ON KitComponents.ItemId = ProductSubgroupItems.ItemId INNER Join ProductSubGroup ON ProductSubgroupItems.ProductSubGroupId = ProductSubGroup.ProductSubGroupId INNER Join ProductGroup ON ProductSubGroup.ProductGroupId = ProductGroup.ProductGroupId WHERE ComponentItemId = 4432 and (ProductGroup.DealerProduct = 0 or ProductGroup.dealerproduct is null) order by ProductGroup.ProductGroupName
|
|
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 = '6' and ie.CategoryValues$5 = '10' and ie.CategoryValues$6 = '3' and ie.CategoryValues$23 = 'item' and ie.CategoryValues$3 = 'Metric' and i.ItemID <> 4432 and ( i.ItemID not in (select psgi.ItemID from ProductSubGroupItems psgi Left Join ProductSubGroup psg on psg.ProductSubGroupID=psgi.ProductSubGroupID Left Join ProductGroup pg on pg.ProductGroupID=psg.ProductGroupID where pg.DealerProduct = 1 ) ) order by i.SellPrice$2
|
|