SELECT p.cSlug, p.CatDescription, p.CommonBrandName, bd.CommonBrandID, p.StandardColor, mp.in_stock, mp.free_shipping, mp.quick_ship, IF(p.StandardColor = 'Other',CONCAT(UCASE(SUBSTRING(p.ColorDescription, 1, 1)),LCASE(SUBSTRING(p.ColorDescription, 2))),p.StandardColor) AS ModelColor, IF(p.StandardColor = 'Other', p.ColorDescription, p.StandardColor) AS ModelColorValue, IF('mattresses' = 'outlet', mp.OutletPrice, IF(mp.Sale = 0,mp.MSRP, IF(mp.MSRP = 0,mp.Sale, IF(mp.Sale > mp.MSRP,mp.MSRP,mp.Sale)))) AS calcPrice, (SELECT COUNT(pbm.pkID) FROM PromotionsByModel AS pbm INNER JOIN Rebates ON (Rebates.PromotionName = pbm.PromotionName AND Rebates.FileName <> '') WHERE pbm.pkProduct = p.pkID AND pbm.EffectiveDate <= CURDATE() AND pbm.ExpirationDate > CURDATE() GROUP BY pbm.pkProduct) AS rwsPromotion, (SELECT COUNT(rbm.pkID) FROM rebatesbymodel AS rbm INNER JOIN Rebates AS r ON r.pkID = rbm.pkRebates WHERE rbm.pkProduct = p.pkID AND r.ExpirationDate > CURDATE() AND r.EffectiveDate < CURDATE() GROUP BY rbm.PromotionName) AS rwsRebates FROM Categories AS c INNER JOIN Category_Groups AS cg ON (c.Category_Group = cg.CategoryCode) INNER JOIN menu_heading AS mh ON (cg.MenuHeading = mh.id) INNER JOIN tbl_products AS p ON (p.cSlug = c.slug AND p.cgSlug = cg.slug AND p.mhSlug = mh.slug) INNER JOIN Brand_Data AS bd ON (bd.pkID = p.pkBrand) INNER JOIN tbl_store_brands AS sb ON (sb.brandID = bd.pkID AND sb.categoryID = c.pkID) INNER JOIN ModelPrice AS mp ON (mp.pkProduct = p.pkID AND mp.SKU = p.SKU AND mp.Available = 1 AND ( ( (IF((mp.Sale = 0 OR ISNULL(mp.Sale)),mp.MSRP,IF((mp.MSRP = 0),mp.Sale,IF((mp.Sale > mp.MSRP),mp.MSRP,mp.Sale))) BETWEEN '0' AND '99999' )))) WHERE ((`p`.`mhSlug` = 'mattresses')) GROUP BY p.pkID<BR><BR>Query execution was interrupted