Time : 12:12:31 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'group by ab.ADVERTISEMENTBOOKINGID order by sos.DUMMYPAGENO asc' at line 12 Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,mpos.VALUE as positionfix,ab.remarks,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID inner join partydetail p on p.PARTYID=ab.PARTY inner join contact co on co.PARTY=p.PARTYID inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY inner join tarrifdetail tf on tf.ID=sos.TARRIF inner join pagesizes ps on ps.ID=tf.PAGESIZE inner join master m on m.MASTERID=tf.COLOR left outer join master mpos on mpos.MASTERID=sos.POSITION where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) and sos.MAGZINEEDITIONS= group by ab.ADVERTISEMENTBOOKINGID order by sos.DUMMYPAGENO asc Time : 12:11:28 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'group by ab.ADVERTISEMENTBOOKINGID order by sos.DUMMYPAGENO asc' at line 12 Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,mpos.VALUE as positionfix,ab.remarks,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID inner join partydetail p on p.PARTYID=ab.PARTY inner join contact co on co.PARTY=p.PARTYID inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY inner join tarrifdetail tf on tf.ID=sos.TARRIF inner join pagesizes ps on ps.ID=tf.PAGESIZE inner join master m on m.MASTERID=tf.COLOR left outer join master mpos on mpos.MASTERID=sos.POSITION where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) and sos.MAGZINEEDITIONS= group by ab.ADVERTISEMENTBOOKINGID order by sos.DUMMYPAGENO asc Time : 07:41:26 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:26 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:26 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:25 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:25 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:14 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:13 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:13 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:13 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:41:13 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:52 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:51 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:51 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:50 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:50 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:40 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:38 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:38 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:38 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID= Time : 07:40:37 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select ACCOUNTLEDGERID,NAME,ACCOUNTGROUPID from accountledger where ISITSTOCK=1 and ACCOUNTLEDGERID=