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 t1.Status=1' at line 2
=> SELECT COUNT( t1.ads_id ) as Total FROM `sd_ads` t1,`sd_user` t0 ,sd_category t2,sd_location t9 WHERE t1.User_Id=t0.User_Id AND t1.Category_Id=t2.Category_Id AND t1.Location_Id=t9.Location_Id And Path= And t1.Status=1