SQL Error found in query: SELECT count(1) FROM v_health as a,disease_list as b where a.d_id=b.id and a.`l_id`= and a.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 a.status=1' at line 1