執(zhí)行SQL發(fā)生錯誤!錯誤:no such column: mod,語句:SELECT COUNT(*) AS sum FROM ay_content a LEFT JOIN ay_content_sort b ON a.scode=b.scode LEFT JOIN ay_content_sort c ON a.subscode=c.scode LEFT JOIN ay_model d ON b.mcode=d.mcode LEFT JOIN ay_content_ext e ON a.id=e.contentid WHERE(a.status=1 AND d.type=2 AND a.date<'2025-07-03 11:41:59') AND((a.title like '%空氣壓縮機(jī)%' OR subtitle like '%空氣壓縮機(jī)%' OR content like '%空氣壓縮機(jī)%' OR tags like '%空氣壓縮機(jī)%') AND mod like '%product%' AND act like '%list%' )
程序版本:2.0.3,
操作系統(tǒng):WINNT,
WEB應(yīng)用:Microsoft-IIS/8.5