Discuz! Database 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 upid=0 order by orderid' at line 1

SELECT * FROM pre_prod_category where chid= AND upid=0 order by orderid

PHP Debug

No.	File	Line	Code
1	prod.php	66	require_once(%s)
2	source/module/prod/prod_brand.php	31	discuz_database::query(%s)
3	source/class/discuz/discuz_database.php	139	db_driver_mysql->query(%s, false, false)
4	source/class/db/db_driver_mysql.php	152	db_driver_mysql->halt(%s, %d, %s)
5	source/class/db/db_driver_mysql.php	223	break()