Time : 10:08:16
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.ORDERNO' at line 10
Raw SQL : select ab.NOOFISSUES,ab.ADVERTISEMENTBOOKINGID,p.NAME,so.netamount  totalnetamount,ab.PAYMENTNOOFISSUES,p.PARTYCODE,p.NAME,ab.ORDERNO,ab.ORDERDATE,td.CODE,
me.DATEOFEDITIONS,so.DUMMYPAGENO,so.AMOUNT,so.discount,
so.discountamount,so.netamount,ab.ISADVANCE from advertisementbooking ab 
inner join suborders so
on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID 
inner join magzineeditions me on me.MAGZINEEDITIONSID=so.MAGZINEEDITIONS
inner join partydetail p on p.PARTYID=ab.PARTY
inner join tarrifdetail td on td.ID=so.TARRIF
where so.ISCANCEL is null and so.BILLSTATUS is null 
and me.MAGZINEEDITIONSID= group by ab.ORDERNO

Time : 09:34: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 AMOUNT from tarrifdetail where ID=

Time : 09:34: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 AMOUNT from tarrifdetail where ID=

Time : 09:11:42
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 10
Raw SQL : select ab.NOOFISSUES,ab.ADVERTISEMENTBOOKINGID,p.NAME,sum(so.netamount) as totalnetamount,ab.PAYMENTNOOFISSUES,p.PARTYCODE,p.NAME,ab.ORDERNO,ab.ORDERDATE,td.CODE,
me.DATEOFEDITIONS,so.DUMMYPAGENO,so.AMOUNT,so.discount,
so.discountamount,so.netamount,ab.ISADVANCE from advertisementbooking ab 
inner join suborders so
on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID 
inner join magzineeditions me on me.MAGZINEEDITIONSID=so.MAGZINEEDITIONS
inner join partydetail p on p.PARTYID=ab.PARTY
inner join tarrifdetail td on td.ID=so.TARRIF
where so.ISCANCEL is null and so.BILLSTATUS is null 
and me.MAGZINEEDITIONSID=

Time : 09:09:35
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' at line 10
Raw SQL : select ab.NOOFISSUES,ab.ADVERTISEMENTBOOKINGID,p.NAME,sum(so.netamount)totalnetamount,ab.PAYMENTNOOFISSUES,p.PARTYCODE,p.NAME,ab.ORDERNO,ab.ORDERDATE,td.CODE,
me.DATEOFEDITIONS,so.DUMMYPAGENO,so.AMOUNT,so.discount,
so.discountamount,so.netamount,ab.ISADVANCE from advertisementbooking ab 
inner join suborders so
on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID 
inner join magzineeditions me on me.MAGZINEEDITIONSID=so.MAGZINEEDITIONS
inner join partydetail p on p.PARTYID=ab.PARTY
inner join tarrifdetail td on td.ID=so.TARRIF
where so.ISCANCEL is null and so.BILLSTATUS is null 
and me.MAGZINEEDITIONSID= group by ab.ADVERTISEMENTBOOKINGID