SQL Error found in query: SELECT count(*) FROM `v_occupations_info` as a,`occup_list` as b where a.`category`=b.id and a.`l_id`= and status=1

Error Message: 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 status=1' at line 1