Product Information
Product Specifications
|
|
|
PageComponents_ProductDetail_SimilarItemsPanel
select * from Item i left join ItemExtension ie on ie.ItemID=i.ItemID where ie.CategorySet = 25 and ie.CategoryValues$23 = 'item' and ie.CategoryValues$3 = 'Metric' and i.ItemID <> 13943 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
|
|