:(

1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY gqh_goods_attr.goods_id HAVING find_in_set('许昕',attr_value) ORDER' at line 1 [ SQL语句 ] : SELECT group_concat(gqh_goods_attr.attr_value) as attr_value,gqh_goods_attr.goods_id,gqh_goods.* FROM `gqh_goods_attr` LEFT JOIN gqh_goods ON gqh_goods_attr.goods_id = gqh_goods.goods_id WHERE ( is_delete=0 and is_real=1 and gqh_goods.attr= ) GROUP BY gqh_goods_attr.goods_id HAVING find_in_set('许昕',attr_value) ORDER BY gqh_goods.goods_num desc,gqh_goods.goods_id desc

错误位置

FILE: /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/Db/Driver.class.php  LINE: 385

TRACE

#0 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/Db/Driver.class.php(385): E('1064:You have a...')
#1 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/Db/Driver.class.php(196): Think\Db\Driver->error()
#2 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/Db/Driver.class.php(1058): Think\Db\Driver->query('SELECT group_co...', false, false)
#3 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/Model.class.php(628): Think\Db\Driver->select(Array)
#4 /data/wwwroot/www.guoqiuhui.net/Application/Home/Controller/GoodsController.class.php(133): Think\Model->select()
#5 [internal function]: Home\Controller\GoodsController->goods()
#6 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/App.class.php(178): ReflectionMethod->invoke(Object(Home\Controller\GoodsController))
#7 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/App.class.php(113): Think\App::invokeAction(Object(Home\Controller\GoodsController), 'goods')
#8 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/App.class.php(213): Think\App::exec()
#9 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/Library/Think/Think.class.php(135): Think\App::run()
#10 /data/wwwroot/www.guoqiuhui.net/ThinkPHP/ThinkPHP.php(100): Think\Think::start()
#11 /data/wwwroot/www.guoqiuhui.net/index.php(33): require('/data/wwwroot/w...')
#12 {main}