程序獲取不到最新的數(shù)據(jù)

數(shù)據(jù)庫(kù)文件被同事給刪了，沒辦法，只能重新采集數(shù)據(jù)，以前沒有問(wèn)題，但是這次導(dǎo)入數(shù)據(jù)庫(kù)后，程序獲取不到最新的數(shù)據(jù)。

$q = "SELECT fc.city_id, city_name, fang_time, IF(area is NULL,0,area), IF(taoshu is NULL,0,taoshu), fcj.id FROM f_city AS fc LEFT JOIN (SELECT * FROM f_chengjiao ORDER by fang_time DESC) AS fcj USING (city_id) GROUP BY fc.city_id";

按區(qū)域排序，數(shù)據(jù)不是最新的，截圖如下：

重新寫代碼，一但關(guān)聯(lián)片區(qū)，就數(shù)據(jù)不對(duì)了。