www.tokyocn.net - Database Error

(1054) Unknown column 'avg_desc' in 'order clause'

SELECT shop.*, count.average, count.rank, count.rank1, count.rank2, count.rank3, count.rank4, count.reviewnum FROM xn_haodian_shop shop INNER JOIN xn_haodian_shopcount count USING(shopid) WHERE shop.`displayorder` IN('0','1') AND shop.`invisible`='0' AND shop.`catid` IN('1') AND shop.`did` IN('3') ORDER BY avg_desc LIMIT 12

PHP Debug

No.	File	Line	Code
1	haodian.php	6	include(%s)
2	plugin.php	47	include(%s)
3	source/plugin/xn_haodian/xn_haodian.inc.php	28	require(%s)
4	source/plugin/xn_haodian/module/xn_haodian_list.php	158	table_xn_haodian_shop->fetch_all_by_search(Array, %s, %d, %d)
5	source/plugin/xn_haodian/table/table_xn_haodian_shop.php	98	discuz_database::fetch_all(%s, Array, %s)
6	source/class/discuz/discuz_database.php	106	discuz_database::query(%s, Array, false, false)
7	source/class/discuz/discuz_database.php	142	db_driver_mysqli->query(%s, false, false)
8	source/class/db/db_driver_mysqli.php	148	db_driver_mysqli->halt(%s, %d, %s)
9	source/class/db/db_driver_mysqli.php	223	break()

Discuz! Database Error