Time : 12:39:29
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.ADVERTISEBOOKINGID' in 'group statement'
Raw SQL : select count(ADVERTISEMENTBOOKINGID) as totalnew_parties from advertisementbooking as ab,partydetail as p,suborders as so where p.PARTYID=ab.PARTY and ab.ADVERTISEMENTBOOKINGID=so.ADVERTISEBOOKINGID  and ORDERNO!='10276' and ORDERNO!='ORD14000060' and ORDERNO!='ORD14000079' and ORDERNO!='ORD14000224' and ORDERNO!='ORD16000193' and p.PARTYCODE=13083 and ISITCANCEL=1 group by ab.ADVERTISEBOOKINGID

Time : 12:33:29
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 so.ADVERTISEBOOKINGID order by so.SUBORDERSID desc limit 0,20' at line 1
Raw SQL : select ab.*,ISPAGEFIX,PARTYCODE,NAME,PARTYID,TARRIF,MAGZINEEDITIONS,PAGENO,AMOUNT,netamount,discountamount,discount,MAGZINEDETAIL,SUBORDERSID,ISCANCEL,so.CANCELDATE as SOCANCELDATE   from advertisementbooking as ab,partydetail as p,suborders as so where p.PARTYID=ab.PARTY and ab.ADVERTISEMENTBOOKINGID=so.ADVERTISEBOOKINGID  and ORDERNO!='10276' and ORDERNO!='ORD14000060' and ORDERNO!='ORD14000079' and ORDERNO!='ORD14000224' and ORDERNO!='ORD16000193' and p.PARTYCODE=13083 and (ISCANCEL<1 OR ISCANCEL IS NULL)  and group by so.ADVERTISEBOOKINGID order by so.SUBORDERSID desc limit 0,20

Time : 12:16:23
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 'order by DISPATCHDATE DESC' at line 1
Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact group by PARTY) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty  and DISPATCHNO= order by DISPATCHDATE DESC

Time : 10:15:27
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 '['PARTYID'] and co.addresstype in(351,350) order by addresstype desc' at line 4
Raw SQL : select p.NAME,p.PARTYID,co.addresstype from  partydetail p
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
where p.PARTYID=Array['PARTYID'] and co.addresstype in(351,350) order by addresstype desc

Time : 10:15:19
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 '['PARTYID'] and co.addresstype in(351,350) order by addresstype desc' at line 4
Raw SQL : select p.NAME,p.PARTYID,co.addresstype from  partydetail p
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
where p.PARTYID=Array['PARTYID'] and co.addresstype in(351,350) order by addresstype desc

Time : 10:15:06
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 '['PARTYID'] and co.addresstype in(351,350) order by addresstype desc' at line 4
Raw SQL : select p.NAME,p.PARTYID,co.addresstype from  partydetail p
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
where p.PARTYID=Array['PARTYID'] and co.addresstype in(351,350) order by addresstype desc

Time : 10:14:32
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 '['PARTYID'] and co.addresstype in(351,350) order by addresstype desc' at line 4
Raw SQL : select p.NAME,p.PARTYID,co.addresstype from  partydetail p
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
where p.PARTYID=Array['PARTYID'] and co.addresstype in(351,350) order by addresstype desc

Time : 10:14:03
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 '['PARTYID'] and co.addresstype in(351,350) order by addresstype desc' at line 4
Raw SQL : select p.NAME,p.PARTYID,co.addresstype from  partydetail p
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
where p.PARTYID=Array['PARTYID'] and co.addresstype in(351,350) order by addresstype desc

Time : 06:38:58
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 'and mt.MASTERTRANSACTIONID=37772' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=37772

Time : 06:38:57
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 'and mt.MASTERTRANSACTIONID=37772' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=37772

Time : 06:38:57
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 'and mt.MASTERTRANSACTIONID=37772' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=37772

Time : 06:38:57
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 'and mt.MASTERTRANSACTIONID=37772' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=37772

Time : 06:38:57
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 'and mt.MASTERTRANSACTIONID=37772' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=37772

Time : 06:38:55
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 'and mt.MASTERTRANSACTIONID=37772' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=37772

Time : 06:28:22
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 'and mt.MASTERTRANSACTIONID=37969' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=37969

Time : 05:18:30
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 '==86232' at line 2
Raw SQL : select inv.*,m.VALUE from invoicedetail inv 
inner join master m on m.MASTERID=inv.ADJUSTMENTMETHODID where inv.TRANSACTIONID==86232

Time : 05:14:49
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 * from invoicedetail where TRANSACTIONID=

Time : 05:14: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 '.ISITPARTY,t.MASTERDRCR,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt' at line 1
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,al.NAME.al.ISITPARTY,t.MASTERDRCR,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID=3 and mt.REFERENCENO='ADV/2017/04/27340'

Time : 04:46:21
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 'mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction' at line 1
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,al.NAME,t.MASTERDRCR,,mt.TRANSACTIONDATE,t.subamount from mastertransaction mt 
inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID
where ACCOUNTVOUCHERTYPEID=3 and mt.REFERENCENO='ADV/2017/04/27340'