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	131	require_once(%s)
2	source/module/prod/prod_brand.php	31	discuz_database::query()
3	source/class/discuz/discuz_database.php	139	db_driver_mysqli->query()
4	source/class/db/db_driver_mysqli.php	149	db_driver_mysqli->halt()
5	source/class/db/db_driver_mysqli.php	224	break()