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