税收减免相关资质查询频道

getlist 调试

PID: 281
WHERE (原始):

Array
(
    [status] => 1
    [pid] => 281
    [aid] => 0
)

手动 SQL: SELECT COUNT(*) FROM modoer_subject s WHERE s.status = '1' AND s.pid = '281' AND s.aid = '0' AND (s.pid = 281 OR s.catid = 281)

手动 SQL 返回值: 164

getcount 返回: 164

WHERE (移除attid后):

Array
(
    [status] => 1
    [pid] => 281
    [aid] => 0
)

JOIN 表: modoer_subject_baike
添加分类条件: (s.pid = 281 OR s.catid = 281)

主查询 SQL (估计):
SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews,pictures,favorites,thumb,content FROM modoer_subject s LEFT JOIN modoer_subject_baike sf ON s.sid = sf.sid WHERE (s.pid = 281 OR s.catid = 281) AND s.status = '1' AND s.pid = '281' AND s.aid = '0' ORDER BY {"finer":"DESC"}

COUNT结果: 164
数据行数: 0