Time : 12:13: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 ISITCOMPLEMENTARY,NOOFISSUES from customernature where CUSTOMERNATUREID=

Time : 10:32: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 '' at line 1
Raw SQL : select AMOUNT from tarrifdetail where ID=

Time : 10:32: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 '' at line 1
Raw SQL : select AMOUNT from tarrifdetail where ID=

Time : 08:43:08
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 DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-07-03' and '2017-07-03' at line 9
Raw SQL : select dr.docketNo,dr.DISPATCHNO,DATE_FORMAT(dr.DISPATCHDATE,'%d %b %Y') as DISPATCHDATE,
p.NAME,co.ADD1,co.ADD2,co.ADD3,csc.NAME as cityname,ssc.NAME as statename,co.PINCODE,dr.SUBJECT,dr.amount from dispatchregister dr
inner join partydetail p on p.PARTYID=dr.FIRMNAME
inner join contact co on co.PARTY=p.PARTYID
left outer join contactperson cp on cp.PARTY=p.PARTYID
left outer join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
left outer join countrystatecity ssc on ssc.COUNTRYSTATECITYID=co.STATE
left outer join countrystatecity cosc on cosc.COUNTRYSTATECITYID=co.COUNTRY
where COURIERCONAME= and DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-07-03' and '2017-07-03' group by dr.DISPATCHREGISTERID order by dr.DISPATCHDATE,dr.DISPATCHNO

Time : 08:41: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 'and DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-07-03' and '2017-07-03' at line 9
Raw SQL : select dr.docketNo,dr.DISPATCHNO,DATE_FORMAT(dr.DISPATCHDATE,'%d %b %Y') as DISPATCHDATE,
p.NAME,co.ADD1,co.ADD2,co.ADD3,csc.NAME as cityname,ssc.NAME as statename,co.PINCODE,dr.SUBJECT,dr.amount from dispatchregister dr
inner join partydetail p on p.PARTYID=dr.FIRMNAME
inner join contact co on co.PARTY=p.PARTYID
left outer join contactperson cp on cp.PARTY=p.PARTYID
left outer join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
left outer join countrystatecity ssc on ssc.COUNTRYSTATECITYID=co.STATE
left outer join countrystatecity cosc on cosc.COUNTRYSTATECITYID=co.COUNTRY
where COURIERCONAME= and DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-07-03' and '2017-07-03' group by dr.DISPATCHREGISTERID order by dr.DISPATCHDATE,dr.DISPATCHNO

Time : 08:05: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 'and DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-06-05' and '2017-07-03' at line 9
Raw SQL : select dr.docketNo,dr.DISPATCHNO,DATE_FORMAT(dr.DISPATCHDATE,'%d %b %Y') as DISPATCHDATE,
p.NAME,co.ADD1,co.ADD2,co.ADD3,csc.NAME as cityname,ssc.NAME as statename,co.PINCODE,dr.SUBJECT,dr.amount from dispatchregister dr
inner join partydetail p on p.PARTYID=dr.FIRMNAME
inner join contact co on co.PARTY=p.PARTYID
left outer join contactperson cp on cp.PARTY=p.PARTYID
left outer join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
left outer join countrystatecity ssc on ssc.COUNTRYSTATECITYID=co.STATE
left outer join countrystatecity cosc on cosc.COUNTRYSTATECITYID=co.COUNTRY
where COURIERCONAME= and DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-06-05' and '2017-07-03' group by dr.DISPATCHREGISTERID order by dr.DISPATCHDATE,dr.DISPATCHNO

Time : 08:04:36
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 DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-05-01' and '2017-05-31' at line 9
Raw SQL : select dr.docketNo,dr.DISPATCHNO,DATE_FORMAT(dr.DISPATCHDATE,'%d %b %Y') as DISPATCHDATE,
p.NAME,co.ADD1,co.ADD2,co.ADD3,csc.NAME as cityname,ssc.NAME as statename,co.PINCODE,dr.SUBJECT,dr.amount from dispatchregister dr
inner join partydetail p on p.PARTYID=dr.FIRMNAME
inner join contact co on co.PARTY=p.PARTYID
left outer join contactperson cp on cp.PARTY=p.PARTYID
left outer join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
left outer join countrystatecity ssc on ssc.COUNTRYSTATECITYID=co.STATE
left outer join countrystatecity cosc on cosc.COUNTRYSTATECITYID=co.COUNTRY
where COURIERCONAME= and DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-05-01' and '2017-05-31' group by dr.DISPATCHREGISTERID order by dr.DISPATCHDATE,dr.DISPATCHNO

Time : 08:02:08
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 DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-05-01' and '2017-05-31' at line 9
Raw SQL : select dr.docketNo,dr.DISPATCHNO,DATE_FORMAT(dr.DISPATCHDATE,'%d %b %Y') as DISPATCHDATE,
p.NAME,co.ADD1,co.ADD2,co.ADD3,csc.NAME as cityname,ssc.NAME as statename,co.PINCODE,dr.SUBJECT,dr.amount from dispatchregister dr
inner join partydetail p on p.PARTYID=dr.FIRMNAME
inner join contact co on co.PARTY=p.PARTYID
left outer join contactperson cp on cp.PARTY=p.PARTYID
left outer join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
left outer join countrystatecity ssc on ssc.COUNTRYSTATECITYID=co.STATE
left outer join countrystatecity cosc on cosc.COUNTRYSTATECITYID=co.COUNTRY
where COURIERCONAME= and DATE_FORMAT(dr.DISPATCHDATE,'%Y-%m-%d') between '2017-05-01' and '2017-05-31' group by dr.DISPATCHREGISTERID order by dr.DISPATCHDATE,dr.DISPATCHNO