anke SELECT DISTINCT p.ProductId, p.Make, p.ModelNo, p.SellingPrice, p.WebFlags, p.ShortDesc, p.EnergyRating, p.StrapLine, p.OldPrice, p.Itemtype, p.Producttype, p.DeliverySurcharge, p.Group1, p.Group2, p.Group3, p.Colour, p.MainImageName, p.ActualStock, p.ManufactureGuarantee, p.LongDesc, p.CashbackValue, p.QtyDueIn, p.DateDueIn, p.QtySold, p.GrossMargin,p.TopSellerInclude, p.TopSellerExclude , pf.FilterOptions FROM productgroups p Inner Join productfilters pf ON p.ModelNo = pf.ModelNo AND pf.Group1Name = p.Group1 AND pf.Group2Name = p.Group2 WHERE p.ProductId IS NOT NULL AND NOT (p.ProductId = 19977 OR p.ProductId = 19978) AND ( p.Make = 'stoves' AND Group1 = 'cookers' AND Group2 = 'dual fuel range cookers' AND Mid(pf.FilterOptions,1,2) = '06' ) GROUP BY p.ModelNo ORDER BY (ProductId=10461) DESC,(ProductId=16249) DESC,(ProductId=18502) DESC,(ProductId=20408) DESC,(ProductId=18292) DESC,ActualStock>0 DESC, QtySold DESC
Stoves Dual Fuel Range Cookers - Buy Stoves Dual Fuel Range Cookers Online | Appliance City
heyFalse
Showing of 10 items
This is the first page This is the first page Prev  [ Page 1 of 1 ]  Next This is the last page This is the last page
Sort by:
Showing of 10 items
This is the first page This is the first page Prev  [ Page 1 of 1 ]  Next This is the last page This is the last page
Sort by: