執(zhí)行SQL發(fā)生錯誤!錯誤:Unknown column 'search_key' in 'where clause',語句: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.scode in ('2','9','32','33','34','35','36','37','38','39','40','124','10','41','42','43','44','45','11','47','48','49','50','51','52','53','54','12','56','57','58','59','60','142','130','131','132','133','134','135','136','137','138','139','140','141','3','13','77','107','108','109','110','78','111','112','113','79','125','114','115','116','117','81','119','118','120','82','83','84','126','127','128','129','15','121','122','123','16','89','90','91','92','93','17','94','95','96','97','99','100','101','102','103','98','106','104','105') OR a.subscode='2,3') AND(a.status=1 AND d.type=2 AND a.date<'2025-07-02 10:01:39') AND(search_key like '%現(xiàn)代風(fēng)格%' )
程序版本:2.0.2,
操作系統(tǒng):Linux,
WEB應(yīng)用:Apache