MySQL Query Error [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 'AND u.attr_id_2 = a.attr_valueid AND u.attr_id_3 = b.attr_valueid AND u.attr_id_' at line 1
SQL: SELECT u.itemid, g.shopid, g.itemid, g. SUBJECT, g.priceo, g.minprice, u.catid, a.attr_text AS chexing, b.attr_text AS tese, c.attr_text AS zhouqi, d.attr_text AS jiesong FROM [tablepre]_itemattribute u, [tablepre]_gooditems g, [tablepre]_attrvalue a, [tablepre]_attrvalue b, [tablepre]_attrvalue c, [tablepre]_attrvalue d WHERE g.itemid = u.itemid AND g.itemid = AND u.attr_id_2 = a.attr_valueid AND u.attr_id_3 = b.attr_valueid AND u.attr_id_5 = c.attr_valueid AND u.attr_id_4 = d.attr_valueid ORDER BY g.itemid LIMIT 0,1

点击这里寻求帮助

PHP Backtrace

File	Line	Function
source\class\db_mysql.class.php	112	db_mysql->halt()
source\class\db.class.php	107	db_mysql->query()
source\function\block.func.php	693	DB::query()
source\function\common.func.php	821	block_sql()
data\cache\tpl\tpl_templates_store_default_good.html.php.php	131	block()
store.php	394	include()