MySQL Query Error: SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews, pictures,favorites,thumb,aid,map_lat,map_lng,c_tab,c_youjian,tel,address,c_english FROM [dbpre]subject s LEFT JOIN [dbpre]subject_youhua sf ON (s.sid = sf.sid) LEFT JOIN [dbpre]subject_youhua sf ON (s.sid = sf.sid) WHERE s.sid IN (SELECT sid FROM [dbpre]subjectatt WHERE attid IN (13438,8514) GROUP BY sid HAVING COUNT(DISTINCT attid)=2) = '' ORDER BY finer DESC LIMIT 0, 10
Error description: Not unique table/alias: 'sf'
Error number: 1066
Date: 2026-04-19 @ 15:29
Script: http://www.95ye.com/anqing/gov/mobile-do-list-catid-920.html
| File | Line | Function |
|---|---|---|
| core/lib/mysql.php | 115 | ms_mysql->_halt() |
| core/lib/activerecord.php | 86 | ms_mysql->query() |
| core/modules/item/model/subject_class.php | 189 | ms_activerecord->get() |
| core/modules/item/mobile/list.php | 179 | msm_item_subject->getlist() |
| core/modules/item/mobile.php | 29 | include() |
| core/modules/item/common.php | 40 | include() |
| index.php | 50 | include() |