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
(45152,28938,23702,10454,50440,9496,43356,30110,50436,47108,47685,14789,37537,21773,13279,39519,44132,46622,53131,53648,13077,32923,48854,47992,21071,22343,40919,46268,49104,2448,48746,8209,8211,8213,14491,20756,22236,27028,31954,31958,35051,36438,39380,62255,80978,101428,107637,126521,127833,134865,137610,9497,113102,8202,8203,8205,8210,8215,8217,8218,8219,8221,11525,11530,13004,13007,14492,16011,16022,16023,17575,17576,17591,20742,20743,20744,20750,22235,22241,22242,23815,23825,25431,25435,28626,30233,31960,31968,33621,33629,35053,35061,35067,36432,36434,36436,37875,37877,37879,39371,39376,39378,39383,41087,41095,42666,42677,44254,45641,45643,45648,47206,50537,51982,53527,53533,54909,56523,56532,58057,58062,61015,61019,62258,63782,65241,65245,73007,73033,73052,74529,76113,77736,79364,80977,80979,80980,80981,85640,85648,87119,87126,87128,87129,96600,96603,99749,99751,99753,99756))
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=mobile&o=Views%2520DESC
---