Couldn't SELECT `price`, `mfr` FROM `specialpricing` WHERE `partnumber` = "X00020266" AND `price` > 0 AND `mfr` = "OEM MTU" AND `company` = "PCI" AND `contract` != "Y" AND (`custuid` = "2663" OR `custuid` = "" OR `custuid` = "0") AND `minqty` <= "1" AND (`startdate` <= "2019-01-18" OR `startdate` = "0000-00-00" OR `startdate` = "") AND (`enddate` >= "2019-01-18" OR `enddate` = "0000-00-00" OR `enddate` = "") ORDER BY `price` ASC LIMIT 1