Kit Information
Kit Components
PageComponents/Applications/ProductGroupSamples.ascx
select top 3 i.Product as Product,'~/productdetail.aspx?ItemID=' + Convert(varchar,i.ItemID) + '&MODSYSID=&ProductSubGroupID=' + Convert(varchar,psg.ProductSubGroupID) as ProductDetailLink, i.SellPrice$2 as Price from Item i left join ItemExtension ie on ie.ItemID=i.ItemID left join ProductSubGroupItems psgi on psgi.ItemID=i.ItemID left join ProductSubGroup psg on psg.ProductSubGroupID=psgi.ProductSubGroupID left join ProductGroup pg on pg.ProductGroupID=psg.ProductGroupID where pg.ProductGroupID = 34 and ie.CategoryValues$23 = 'ITEM' and (pg.DealerProduct <> 1 or pg.DealerProduct is null)
Fishing Reel Bearing Lube
PageComponents/Applications/ProductGroupSamples.ascx
select top 3 i.Product as Product,'~/productdetail.aspx?ItemID=' + Convert(varchar,i.ItemID) + '&MODSYSID=&ProductSubGroupID=' + Convert(varchar,psg.ProductSubGroupID) as ProductDetailLink, i.SellPrice$2 as Price from Item i left join ItemExtension ie on ie.ItemID=i.ItemID left join ProductSubGroupItems psgi on psgi.ItemID=i.ItemID left join ProductSubGroup psg on psg.ProductSubGroupID=psgi.ProductSubGroupID left join ProductGroup pg on pg.ProductGroupID=psg.ProductGroupID where pg.ProductGroupID = 35 and ie.CategoryValues$23 = 'ITEM' and (pg.DealerProduct <> 1 or pg.DealerProduct is null)
Fishing Reel Bearing Tools
|
|
|
|