SQL Error found in query: SELECT count(1) FROM `v_pdt_domestic` as a,`pdt_domestic_list` as b where a.`pdt_domestic_id`=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