所有分类
  • 找建材

08CMS Info: MySQL Query Error

Time: 2018-1-24 15:22
SQL: SELECT a.*,c.* FROM cms_archives19 a INNER JOIN cms_archives_103 c ON c.aid=a.aid WHERE a.chid ='103' AND a.caid ='513' AND a.ccid31 ='3005' AND a.checked=1 AND (a.enddate=0 OR a.enddate>'1516778540') ORDER BY a.ccid42 DESC,a.refreshdate DESC LIMIT 0,10
Error: Unknown column 'a.ccid42' in 'order clause'
Errno.: 1054