Couldn't perform SELECT: .SELECT deal_breaks, deal_details, IF(deal_act > CURDATE(), IF(deal_exp IS NULL, DATE_FORMAT(deal_act, 'Valid After %c/%e/%Y'), IF(deal_act=deal_exp, DATE_FORMAT(deal_exp, 'Valid On %c/%e/%Y'), CONCAT(DATE_FORMAT(deal_act, 'Valid Between %c/%e/%Y'), DATE_FORMAT(deal_exp, ' - %c/%e/%Y')) ) ), IFNULL(DATE_FORMAT(deal_exp, 'Valid Thru %c/%e/%Y'), 'No Expiration')) AS range_display, rid, logo, logo_width, logo_height, r_name, r_phone, r_locations FROM deals JOIN restaurants ON deals.restaurant_id=rid WHERE did = 264 AND (deal_exp >= CURDATE() OR deal_exp IS NULL) ORDER BY rank DESC