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 jour_sub_id = 3 Group By issue_master.iss_name, vol_issue_master.pu' at line 6

Last SQL Query:
SELECT count(paper_pub_id) as cnt , issue_master.iss_name, vol_issue_master.pub_id, vol_issue_master.jour_type_id, vol_issue_master.jour_sub_id,vol_issue_master.vol_id, vol_issue_master.iss_id, vol_issue_master.month_id, vol_issue_master.year_id,vol_issue_master.last_date, vol_issue_master.pub_date FROM vol_issue_master inner join issue_master on vol_issue_master.iss_id =issue_master.iss_id inner join paper_publish_master On paper_publish_master.pub_id= vol_issue_master.pub_id Where vol_issue_master.is_publish > 0 and vol_issue_master.vol_id = and jour_sub_id = 3 Group By issue_master.iss_name, vol_issue_master.pub_id, vol_issue_master.jour_type_id, vol_issue_master.jour_sub_id,vol_issue_master.vol_id, vol_issue_master.iss_id, vol_issue_master.month_id, vol_issue_master.year_id,vol_issue_master.last_date, vol_issue_master.pub_date Order by CAST(issue_master.iss_name AS SIGNED )