Time : 15:08:37
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:45:32
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'MOBILENO' in field list is ambiguous
Raw SQL : select csc.NAME as cityname,CONTACTPERSONID,PARTYCODE,p.NAME as partyname,p.EMAIL,
cp.NAME as cpname,m.VALUE,DATE_FORMAT(dob,'%d %b %Y') as dob,
MOBILENO,EMAILID from partydetail as p left outer join contactperson as cp 
on p.PARTYID=cp.PARTY
left outer join contact co on co.PARTY=p.PARTYID
left outer join countrystatecity as csc on csc.COUNTRYSTATECITYID=co.CITY 
left outer join master m on m.MASTERID=cp.DESIGNATION where 1=1 and DATE_FORMAT(dob, '%c-%d') BETWEEN DATE_FORMAT('2017-05-21', '%c-%d')  AND DATE_FORMAT('2017-05-21', '%c-%d') group by co.PARTY order by dob asc

Time : 05:43:24
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'csc.PARTY' in 'on clause'
Raw SQL : select csc.NAME as cityname,CONTACTPERSONID,PARTYCODE,p.NAME as partyname,p.EMAIL,
cp.NAME as cpname,m.VALUE,DATE_FORMAT(dob,'%d %b %Y') as dob,
MOBILENO,EMAILID from partydetail as p left outer join contactperson as cp 
on p.PARTYID=cp.PARTY
left outer join countrystatecity as csc on csc.PARTY=p.PARTYID 
left outer join master m on m.MASTERID=cp.DESIGNATION where 1=1 and DATE_FORMAT(dob, '%c-%d') BETWEEN DATE_FORMAT('2017-05-21', '%c-%d')  AND DATE_FORMAT('2017-05-21', '%c-%d') order by dob asc