1054:Unknown column 'a.end_price' in 'order clause' [ SQL语句 ] : SELECT a.* FROM knight_motor as a INNER JOIN knight_motor_brand as b on a.brand_id = b.id WHERE ( a.status >= 8 ) AND ( a.brand_id = 64 ) ORDER BY a.end_price asc LIMIT 0,20

错误位置

FILE: /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php  LINE: 350

TRACE

#0 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php(350): E('1054:Unknown co...')
#1 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php(180): Think\Db\Driver->error()
#2 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php(946): Think\Db\Driver->query('SELECT a.* FROM...', false)
#3 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Model.class.php(579): Think\Db\Driver->select(Array)
#4 /webroot/www/usedcar.knight-un.com/App/Home/Controller/IndexController.class.php(222): Think\Model->select()
#5 /webroot/www/usedcar.knight-un.com/App/Home/Controller/IndexController.class.php(124): Home\Controller\IndexController->commonlist()
#6 [internal function]: Home\Controller\IndexController->lists()
#7 /webroot/www/libraries/ThinkPHP3.2/Library/Think/App.class.php(173): ReflectionMethod->invoke(Object(Home\Controller\IndexController))
#8 /webroot/www/libraries/ThinkPHP3.2/Library/Think/App.class.php(110): Think\App::invokeAction(Object(Home\Controller\IndexController), 'lists')
#9 /webroot/www/libraries/ThinkPHP3.2/Library/Think/App.class.php(204): Think\App::exec()
#10 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Think.class.php(120): Think\App::run()
#11 /webroot/www/libraries/ThinkPHP3.2/ThinkPHP.php(97): Think\Think::start()
#12 /webroot/www/usedcar.knight-un.com/index.php(31): require('/webroot/www/li...')
#13 {main}