我有一个查询,我试图在顶部按最近的日期排序,在底部按最旧的结果排序。这是查询SELECTheadline,story,DATE_FORMAT(date,"%d-%M-%Y")ASdate,name,logo,tpf_parks.park_id,url,alt,descriptionFROMtpf_newsINNERJOINtpf_parksONtpf_news.park_id=tpf_parks.park_idLEFTJOINtpf_imagesONtpf_news.news_id=tpf_images.news_idORDERBYdateDESC虽然结果排序错误,它仅按天排序,因此结