Time : 18:57:07 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 : 18:41: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 '' at line 1 Raw SQL : select * from tarrifdetail tf inner join pagedetail pd on pd.PAGEDETAILID=tf.PAGEDETAIL where tf.ID= Time : 17:56:02 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 ad.*,p.NAME from advertisementbooking ad inner join partydetail p on p.PARTYID=ad.PARTY where ADVERTISEMENTBOOKINGID= Time : 17:55: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 4 Raw SQL : select sos.SUBORDERSID,ab.PAYMENTNOOFISSUES,sos.TARRIF,sos.AMOUNT,sos.discount,sos.discountamount,sos.netamount,sos.MAGZINEEDITIONS from advertisementbooking ab inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID inner join magzineeditions me on me.MAGZINEEDITIONSID=sos.MAGZINEEDITIONS where sos.SUBORDERSID= Time : 05:42:34 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 'or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ss.m' at line 11 Raw SQL : select p.PARTYCODE, p.NAME,co.ADD1,co.ADD2,co.ADD3,co.PINCODE,co.PHONE,cscc.NAME as cityname,cscd.NAME as districtname,cscc.CODE,cscs.shortname ,cscs.NAME as statename,cscco.NAME as countryname, cp.NAME as cpname,cp.MOBILENO from partydetail p inner join subscription ss on ss.PARTY=p.PARTYID left outer join contact co on p.PARTYID=co.PARTY left outer join contactperson cp on cp.PARTY=p.PARTYID left outer join countrystatecity cscc on cscc.COUNTRYSTATECITYID=co.CITY left outer join countrystatecity cscd on cscd.COUNTRYSTATECITYID=co.DISTRICT left outer join countrystatecity cscs on cscs.COUNTRYSTATECITYID=co.STATE left outer join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY where 1=1 and (ss.renewalEditions>= or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ss.mgznpostbyid=4 and co.addresstype=350 group by p.PARTYID order by cscc.CODE asc Time : 05:42: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 ab.mgznpostbyid=4 and co.addresstype=350 group by p.PARTYID order by cscc.' at line 11 Raw SQL : select p.PARTYCODE, p.NAME,co.ADD1,co.ADD2,co.ADD3,co.PINCODE,co.PHONE,cscc.NAME as cityname,cscd.NAME as districtname,cscc.CODE,cscs.shortname ,cscs.NAME as statename,cscco.NAME as countryname, cp.NAME as cpname,cp.MOBILENO from partydetail p inner join advertisementbooking ab on ab.PARTY=p.PARTYID inner join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID left outer join contact co on p.PARTYID=co.PARTY left outer join contactperson cp on cp.PARTY=p.PARTYID left outer join countrystatecity cscc on cscc.COUNTRYSTATECITYID=co.CITY left outer join countrystatecity cscd on cscd.COUNTRYSTATECITYID=co.DISTRICT left outer join countrystatecity cscs on cscs.COUNTRYSTATECITYID=co.STATE left outer join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY where 1=1 and ab.ISITCANCEL is null and so.MAGZINEEDITIONS= and ab.mgznpostbyid=4 and co.addresstype=350 group by p.PARTYID order by cscc.CODE asc