Error in query SELECT id, DATE_FORMAT(time, '%H:%i') as times, title, contact, type, city FROM eng_trade_sell WHERE rdate='06022019' AND type=3 AND (end_time="0000-00-00 00:00:00" OR end_time>now()) ORDER BY time DESC LIMIT 0,66:Unknown column 'rdate' in 'where clause'