SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,if(p.CustomDescription IS NOT NULL AND p.CustomDescription <> '', p.CustomDescription, p.ModelDescription) AS ModelDescription,if(p.thumb LIKE 'http%',p.thumb, concat('/uploads/products/',p.thumb)) AS thumb ,if(p.large LIKE 'http%',p.large, concat('/uploads/products/',p.large)) AS large , mp.PowerBuy, mp.quick_ship, bd.preferred ,IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS SortPrice, bd.CommonBrandID, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU FROM tbl_store_brands AS sb INNER JOIN Brand_Data AS bd ON bd.pkID = sb.brandID+0 INNER JOIN tbl_products AS p ON sb.categoryID = p.pkCategory AND sb.brandID = p.pkBrand INNER JOIN ModelPrice AS mp ON (p.SKU = mp.SKU AND p.pkSKU = mp.pkSKU) WHERE p.mhSlug = 'cooking' AND cgSlug = 'ovens' AND cSlug = 'electric-with-microwave-ovens' AND mp.Available = 1 AND ((CommonBrandID = 'KTA')) GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU
Temperature Probe - Allows accurate measurement of internal temperatures of meats, poultry, and casseroles without having to open the oven so that food can be cooked perfectly., EasyConvect Conversion System - Takes guesswork out of convection cooking by ensuring you can get exceptional results when experimenting with new or familiar recipes., 5.0 Cu. Ft. Capacity (lower oven) - Provides an extra-large cooking capacity that's unsurpassed among 30" wall ovens and is perfect for large turkeys and roasts. It can even make multiple dishes at once., 1.4 Cu. Ft. Capacity (upper oven) - Provides spacious cooking capacity while complementing your lower convection oven., Crispwave Microwave Technology and Crisper Pan (upper oven) - Allows grilling, frying and convection cooking in the microwave. The specially designed crisper pan can be used to brown, crisp, and pan-fry foods.
Request More Info Check for Special Offers
