MySQL Query Error: SELECT COUNT(*) FROM [dbpre]subject s LEFT JOIN [dbpre]subject_wangzhan sf ON (s.sid = sf.sid) LEFT JOIN [dbpre]subject_wangzhan sf ON (s.sid = sf.sid) WHERE status = '1' AND pid = '34' AND city_id = '4068' AND exists(SELECT 1 FROM [dbpre]subjectatt st WHERE s.sid=st.sid AND st.attid IN (45,5028) GROUP BY st.sid HAVING COUNT(st.sid) = 2)
Error description: Not unique table/alias: 'sf'
Error number: 1066
Date: 2026-03-28 @ 19:06
Script: http://95ye.com/baoding/shop/list-catid-34-aid-0.html
| File | Line | Function |
|---|---|---|
| core/lib/mysql.php | 115 | ms_mysql->_halt() |
| core/lib/activerecord.php | 191 | ms_mysql->query() |
| core/modules/item/model/subject_class.php | 162 | ms_activerecord->count() |
| core/modules/item/list.php | 215 | msm_item_subject->getlist() |
| core/modules/item/common.php | 40 | include() |
| index.php | 56 | include() |