Time : 11:01: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,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc' at line 10
Raw SQL : select p.PARTYID,p.NAME,sum(sos.NOOFADD) as NOOFADD,sos.DUMMYPAGENO,sos.TARRIF,sos.AMOUNT as rate,
(sos.AMOUNT * sum(sos.NOOFADD)) as finalamount,
(sos.discountamount * sum(sos.NOOFADD)) as finaldiscountamount,
((sos.AMOUNT * sum(sos.NOOFADD))-(sos.discountamount * sum(sos.NOOFADD))) as finalnetamount,
tf.CODE from advertisementbooking ab
inner join suborders sos on ab.ADVERTISEMENTBOOKINGID=sos.ADVERTISEBOOKINGID
inner join tarrifdetail tf on tf.ID=sos.TARRIF
inner join partydetail p on p.PARTYID=ab.PARTY 
where sos.MAGZINEEDITIONS between 149 and 149 and p.PARTYID=11 and (sos.ISCANCEL is null || sos.ISCANCEL=0) and ab.ADVERTISEMENTBOOKINGID= 
group by ab.ADVERTISEMENTBOOKINGID,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc

Time : 11:01:24
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,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc' at line 10
Raw SQL : select p.PARTYID,p.NAME,sum(sos.NOOFADD) as NOOFADD,sos.DUMMYPAGENO,sos.TARRIF,sos.AMOUNT as rate,
(sos.AMOUNT * sum(sos.NOOFADD)) as finalamount,
(sos.discountamount * sum(sos.NOOFADD)) as finaldiscountamount,
((sos.AMOUNT * sum(sos.NOOFADD))-(sos.discountamount * sum(sos.NOOFADD))) as finalnetamount,
tf.CODE from advertisementbooking ab
inner join suborders sos on ab.ADVERTISEMENTBOOKINGID=sos.ADVERTISEBOOKINGID
inner join tarrifdetail tf on tf.ID=sos.TARRIF
inner join partydetail p on p.PARTYID=ab.PARTY 
where sos.MAGZINEEDITIONS between 149 and 149 and p.PARTYID=11 and (sos.ISCANCEL is null || sos.ISCANCEL=0) and ab.ADVERTISEMENTBOOKINGID= 
group by ab.ADVERTISEMENTBOOKINGID,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc

Time : 11:00:45
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,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc' at line 10
Raw SQL : select p.PARTYID,p.NAME,sum(sos.NOOFADD) as NOOFADD,sos.DUMMYPAGENO,sos.TARRIF,sos.AMOUNT as rate,
(sos.AMOUNT * sum(sos.NOOFADD)) as finalamount,
(sos.discountamount * sum(sos.NOOFADD)) as finaldiscountamount,
((sos.AMOUNT * sum(sos.NOOFADD))-(sos.discountamount * sum(sos.NOOFADD))) as finalnetamount,
tf.CODE from advertisementbooking ab
inner join suborders sos on ab.ADVERTISEMENTBOOKINGID=sos.ADVERTISEBOOKINGID
inner join tarrifdetail tf on tf.ID=sos.TARRIF
inner join partydetail p on p.PARTYID=ab.PARTY 
where sos.MAGZINEEDITIONS between 149 and 149 and p.PARTYID=11 and (sos.ISCANCEL is null || sos.ISCANCEL=0) and ab.ADVERTISEMENTBOOKINGID= 
group by ab.ADVERTISEMENTBOOKINGID,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc

Time : 10:54:26
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ORD17000102' in 'where clause'
Raw SQL : select PARTYID from partydetail where PARTYCODE=ORD17000102

Time : 10:48:46
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  and p.PARTYID=2262 and (sos.ISCANCEL is null || sos.ISCANCEL=0)
group by ab' at line 9
Raw SQL : select p.PARTYID,p.NAME,sum(sos.NOOFADD) as NOOFADD,sos.DUMMYPAGENO,sos.TARRIF,sos.AMOUNT as rate,
(sos.AMOUNT * sum(sos.NOOFADD)) as finalamount,
(sos.discountamount * sum(sos.NOOFADD)) as finaldiscountamount,
((sos.AMOUNT * sum(sos.NOOFADD))-(sos.discountamount * sum(sos.NOOFADD))) as finalnetamount,
tf.CODE from advertisementbooking ab
inner join suborders sos on ab.ADVERTISEMENTBOOKINGID=sos.ADVERTISEBOOKINGID
inner join tarrifdetail tf on tf.ID=sos.TARRIF
inner join partydetail p on p.PARTYID=ab.PARTY 
where sos.MAGZINEEDITIONS between  and  and p.PARTYID=2262 and (sos.ISCANCEL is null || sos.ISCANCEL=0)
group by ab.ADVERTISEMENTBOOKINGID,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc

Time : 10:47: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 'and ) and p.PARTYID=2262 and (sos.ISCANCEL is null || sos.ISCANCEL=0)
group by a' at line 9
Raw SQL : select p.PARTYID,p.NAME,sum(sos.NOOFADD) as NOOFADD,sos.DUMMYPAGENO,sos.TARRIF,sos.AMOUNT as rate,
(sos.AMOUNT * sum(sos.NOOFADD)) as finalamount,
(sos.discountamount * sum(sos.NOOFADD)) as finaldiscountamount,
((sos.AMOUNT * sum(sos.NOOFADD))-(sos.discountamount * sum(sos.NOOFADD))) as finalnetamount,
tf.CODE from advertisementbooking ab
inner join suborders sos on ab.ADVERTISEMENTBOOKINGID=sos.ADVERTISEBOOKINGID
inner join tarrifdetail tf on tf.ID=sos.TARRIF
inner join partydetail p on p.PARTYID=ab.PARTY 
where sos.MAGZINEEDITIONS between ( and ) and p.PARTYID=2262 and (sos.ISCANCEL is null || sos.ISCANCEL=0)
group by ab.ADVERTISEMENTBOOKINGID,tf.ID
order by ab.ADVERTISEMENTBOOKINGID asc

Time : 10:41:44
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 '00:00:00' at line 1
Raw SQL : select MAGZINEEDITIONSID from magzineeditions where DATE_FORMAT(DATEOFEDITIONS,'%Y-%m-%d')=2017-06-15 00:00:00

Time : 10:41:33
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 '00:00:00' at line 1
Raw SQL : select MAGZINEEDITIONSID from magzineeditions where DATE_FORMAT(DATEOFEDITIONS,'%Y-%m-%d')=2017-06-15 00:00:00

Time : 08:29:06
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.addresstype' in 'where clause'
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 ab.addresstype=c.addresstype  order by DISPATCHDATE DESC

Time : 08:28:06
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.addresstype' in 'where clause'
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 ab.addresstype=c.addresstype  order by DISPATCHDATE DESC

Time : 08:28:04
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.addresstype' in 'where clause'
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 ab.addresstype=c.addresstype  order by DISPATCHDATE DESC

Time : 07:57:31
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sos.POSITION' in 'on clause'
Raw SQL : select inv.REFERENCENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,inv.adjustmentamount,sos.DUMMYPAGENO 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 invoicedetail inv on inv.suborder=sos.SUBORDERSID
left outer join master mpos on mpos.MASTERID=sos.POSITION
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) and sos.BILLSTATUS='Bill Generated'
and sos.MAGZINEEDITIONS=148
 group by ab.ADVERTISEMENTBOOKINGID
  order by inv.REFERENCENO asc

Time : 07:49:12
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'POSITION' in 'field list'
Raw SQL : select MAGZINEEDITIONS,ADVERTISEMENTBOOKINGID,ORDERNO,PARTY,NAME,PAGENO,DUMMYPAGENO,TARRIF,PAGESIZE,ISPAGEFIX,REMARKS,SUBORDERSID,POSITION  from advertisementbooking,suborders,(select PARTYID,NAME from partydetail) as aspartydetail where advertisementbooking.ADVERTISEMENTBOOKINGID=suborders.ADVERTISEBOOKINGID and advertisementbooking.PARTY=aspartydetail.PARTYID and (ISCANCEL=0 || ISCANCEL IS NULL)  and suborders.MAGZINEEDITIONS=149 order by ADVERTISEMENTBOOKINGID asc limit 0,20

Time : 07:42:32
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'DISPATCHNO' in 'field list'
Raw SQL : select MAX(DISPATCHNO) as MAXDISPATCHNO from dispatchregister where DISPATCHDATE BETWEEN '2017-04-01' and '2018-03-31'