CDbException

CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054
Unknown column '20DESC' in 'order clause'. The SQL statement executed was:
SELECT DISTINCT `t`.`Id` AS `t0_c0`, `t`.`UserId` AS `t0_c1`, `t`.`Type` AS
`t0_c2`, `t`.`Title` AS `t0_c3`, `t`.`TitleTranslated` AS `t0_c4`,
`t`.`Alias` AS `t0_c5`, `t`.`Description` AS `t0_c6`, `t`.`DesTranslated`
AS `t0_c7`, `t`.`Tags` AS `t0_c8`, `t`.`IsFeatured` AS `t0_c9`,
`t`.`ReferrerUrl` AS `t0_c10`, `t`.`ReferrerName` AS `t0_c11`, `t`.`Status`
AS `t0_c12`, `t`.`Created` AS `t0_c13`, `t`.`Updated` AS `t0_c14`,
`t`.`Views` AS `t0_c15`, `t`.`Exposures` AS `t0_c16`, `t`.`Shares` AS
`t0_c17`, `t`.`Comments` AS `t0_c18`, `t`.`Useful` AS `t0_c19`,
`t`.`Unuseful` AS `t0_c20`, `t`.`c_year` AS `t0_c21`, `t`.`c_month` AS
`t0_c22`, `Translation`.`Title` AS `t1_c1`, `Translation`.`Description` AS
`t1_c3`, `Translation`.`Locale` AS `t1_c5`, `Translation`.`TranslatedId` AS
`t1_c4` FROM `news_briefs` `t`  LEFT JOIN `news_briefs_translated`
`Translation` ON (`Translation`.`Id`=`t`.`Id`)  WHERE (t.Type != 'selfhelp'
AND t.Status>=0 AND t.id IN
(24097,25027,52583,36912,33377,26759,25700,53821,8844,8417,49221,53594,23892,32758,45484,51041,51695,44727,25498,2291,47076,50655,26540,26760,42516,12,10016,21231,27562,28903,31818,33585,35459,50656,53132,17,9030,28968,51488,8818,28232,32293,41123,45093,9436,24774,29839,43644,50657,30074,50402,1041,4089,5829,11331,20979,23158,28467,31757,33848,35866,37102,37288,46821,47023,50161,51040,12792,25922,52352,24775,25251,32292,36081,48228,51669,52103,3170,15813,19383,21853,34479,34913,38167,42102,46560,47433,48227,3342,13050,13842,14743,15812,22130,27998,30073,33583,35122,39939,42814,20,25,2290,9029,9630,11786,12606,13448,18487,18697,22309,23634,24364,25222,26539,32924,34695,44100,45119,46162,47463,48230,50863,52793,36535,18,4973,7572,9183,9435,12029,13645,19816,21587,30836,33376,34071,38346,40173,42103,51268,51696,52794,22536,28465,9875,17799,33849,36270,39937))
ORDER BY Views%20DESC LIMIT 16.

CDbException: CDbCommand 无法执行 SQL 语句: SQLSTATE[42S22]: Column
not found: 1054 Unknown column '20DESC' in 'order clause' in
/home/www/sites/framework/db/CDbCommand.php:541
Stack trace:
#0 /home/www/sites/framework/db/CDbCommand.php(395):
CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/www/sites/framework/db/ar/CActiveFinder.php(761):
CDbCommand->queryAll()
#2 /home/www/sites/framework/db/ar/CActiveFinder.php(422):
CJoinElement->runQuery(Object(CJoinQuery))
#3 /home/www/sites/framework/db/ar/CActiveFinder.php(68):
CJoinElement->find(Object(CDbCriteria))
#4 /home/www/sites/framework/db/ar/CActiveRecord.php(1302):
CActiveFinder->query(Object(CDbCriteria), true)
#5 /home/www/sites/framework/db/ar/CActiveRecord.php(1416):
CActiveRecord->query(Object(CDbCriteria), true)
#6
/home/www/sites/techbrood/protected/modules/News/services/NewsBriefService.php(273):
CActiveRecord->findAll(Object(CDbCriteria))
#7
/home/www/sites/techbrood/protected/modules/News/services/NewsBriefService.php(226):
NewsBriefService->searchWithSphinx(Array)
#8 /home/www/sites/techbrood/protected/base/Cms.php(182):
NewsBriefService->searchByKeywords(Array)
#9
/home/www/sites/techbrood/protected/modules/News/components/BriefListWidget.php(17):
Cms::service('News/NewsBrief/...', Array)
#10
/home/www/sites/techbrood/protected/extensions/helpers/Template.php(38):
BriefListWidget->run()
#11 /home/www/sites/techbrood/themes/techbrood/views/briefs.php(23):
Template::widget('MAIN_CONTENT_BR...', 'application.mod...')
#12 /home/www/sites/framework/web/CBaseController.php(126):
require('/home/www/sites...')
#13 /home/www/sites/framework/web/CBaseController.php(95):
CBaseController->renderInternal('/home/www/sites...', NULL, true)
#14 /home/www/sites/framework/web/CController.php(869):
CBaseController->renderFile('/home/www/sites...', NULL, true)
#15 /home/www/sites/framework/web/CController.php(782):
CController->renderPartial('/briefs', NULL, true)
#16
/home/www/sites/techbrood/protected/controllers/CmsBaseController.php(82):
CController->render('/briefs')
#17
/home/www/sites/techbrood/protected/controllers/DefaultController.php(40):
CmsBaseController->showTemplate()
#18 /home/www/sites/framework/web/actions/CInlineAction.php(49):
DefaultController->actionIndex()
#19 /home/www/sites/framework/web/CController.php(308):
CInlineAction->runWithParams(Array)
#20 /home/www/sites/framework/web/CController.php(286):
CController->runAction(Object(CInlineAction))
#21 /home/www/sites/framework/web/CController.php(265):
CController->runActionWithFilters(Object(CInlineAction), Array)
#22 /home/www/sites/framework/web/CWebApplication.php(282):
CController->run('index')
#23 /home/www/sites/framework/web/CWebApplication.php(141):
CWebApplication->runController('default/index')
#24 /home/www/sites/framework/base/CApplication.php(168):
CWebApplication->processRequest()
#25 /home/www/sites/techbrood/index.php(31): CApplication->run()
#26 {main}
REQUEST_URI=/briefs?q=design&o=Views%2520DESC
---