all ads - query error

[cnczone]

I got this error when I click on the all ads

MySQL error reported!

Script: showcat

Query: SELECT id,user,userid,cat,title,bigimage,views, id*0+RAND() as rand_col FROM products WHERE approved='1' AND status='0' AND cat in () ORDER BY rand_col DESC

Result: 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 ') ORDER BY rand_col DESC' at line 1

Database handle: Resource id #37

[Michael P]

1) Please be more explicit in your titles.
2) Check for other threads which may relate to your issue first, it'll save you time:

Here's a new error...

[cnczone]

Ok, thank's for the reply.