Time : 18:29:12
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=' at line 4
Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount,t.INSTRUMENTDATE,t.REFERENCENO as instno,t.NARRATIONS as transnarration 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=

Time : 15:09:10
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 ipaddress from p_customers where customerid=

Time : 11:02:36
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'noofdownloads' cannot be null
Raw SQL : insert into p_perdaydownloads(customerid,noofdownloads,donwloaddate) values(:customerid,:noofdownloads,:donwloaddate)

Time : 11:00:47
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'noofdownloads' cannot be null
Raw SQL : insert into p_perdaydownloads(customerid,noofdownloads,donwloaddate) values(:customerid,:noofdownloads,:donwloaddate)

Time : 10:58:47
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 ipaddress from p_customers where customerid=

Time : 10:58:14
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 ipaddress from p_customers where customerid=

Time : 10:58: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 ipaddress from p_customers where customerid=

Time : 10:58: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 ipaddress from p_customers where customerid=

Time : 05:33:19
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.fromDate' in 'where clause'
Raw SQL : select distinct p.NAME,p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,concat(ifnull(c.add2,''),' ',ifnull(c.add3,'')) add2,csc.CODE,csc.NAME cityname,country.NAME countryname,cstate.NAME statename,cstate.shortname,district.NAME districtname,country.name country,c.PINCODE,concat(c.STDCODE,c.PHONE) PHONE,person.NAME cpname,ifnull(person.MOBILENO,c.mobile) MOBILENO ,min(person.CONTACTPERSONID),p.partyid, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p 
 inner join subscription sub on sub.PARTY = p.PARTYID 
 inner join magzinedetail m on ifnull(s.MAGZINENAME,1) = m.MAGZINEDETAILID
 inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL
 left outer join contactperson person on person.PARTY = p.PARTYID 
left outer join dealsin dl on dl.PARTY=p.PARTYID
left outer join master ms on ms.MASTERID=person.greeting 
left outer join master mspg on mspg.MASTERID=p.GREETING
inner join contact c on p.PARTYID = c.PARTY left outer join countrystatecity csc on  c.CITY = csc.COUNTRYSTATECITYID left outer join countrystatecity cstate on  c.state =cstate.countrystatecityid  left outer join countrystatecity district on  csc.PARENTID  = district.COUNTRYSTATECITYID left outer join countrystatecity country ON cstate.PARENTID =country.COUNTRYSTATECITYID    where 1=1   and c.addresstype=350
   
and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 169
and s.fromDate <= me.DATEOFEDITIONS and ifnull(s.toDate,me.DATEOFEDITIONS) >= me.DATEOFEDITIONS
and  (iscontinue = 1 or ifnull(s.isEom,me.isEom) = me.isEom)


   and sub.mgznpostbyid=2 group by  p.partyid  order by cstate.CODE,district.CODE,csc.CODE asc