Time : 12:23:27
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 productId,productName from product where category=

Time : 11:03:01
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
Raw SQL : select p.PARTYID,p.PARTYCODE,p.NAME,sub.AMOUNT,
sub.DISCOUNTAMOUNT,sub.totalAmt,
DATE_FORMAT(sub.BILLDATE,'%d %M %Y') as BILLDATE,
DATE_FORMAT(sub.fromDate,'%d %M %Y') as fromDate,
DATE_FORMAT(sub.toDate,'%d %M %Y') as toDate,cn.NATURE,mgzn.NAME as mgznpostvalue,
sub.BILLNO,csc.NAME as cityname,csc.CODE as filecode from subscription sub
inner join invoicedetail inv on inv.REFERENCENO=sub.BILLNO
inner join transaction t on t.TRANSACTIONID=inv.TRANSACTIONID
inner join mastertransaction mt on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join partydetail p on p.PARTYID=sub.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
inner join customernature cn on cn.CUSTOMERNATUREID=sub.CUSTOMERNATURE
inner join mgznpostby mgzn on mgzn.mgznpostbyid=sub.mgznpostbyid
where sub.ISCANCEL is null and cn.ISITCOMPLEMENTARY=0 and sub.BILLSTATUS='Bill Generated'
and DATE_FORMAT(sub.toDate,'%Y-%m-%d')='2017-05-15' group by p.PARTYID

Time : 11:00:04
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
Raw SQL : select p.PARTYID,p.PARTYCODE,p.NAME,sub.AMOUNT,
sub.DISCOUNTAMOUNT,sub.totalAmt,
DATE_FORMAT(sub.BILLDATE,'%d %M %Y') as BILLDATE,
DATE_FORMAT(sub.fromDate,'%d %M %Y') as fromDate,
DATE_FORMAT(sub.toDate,'%d %M %Y') as toDate,cn.NATURE,mgzn.NAME as mgznpostvalue,
sub.BILLNO,csc.NAME as cityname,csc.CODE as filecode from subscription sub
inner join invoicedetail inv on inv.REFERENCENO=sub.BILLNO
inner join transaction t on t.TRANSACTIONID=inv.TRANSACTIONID
inner join mastertransaction mt on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join partydetail p on p.PARTYID=sub.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
inner join customernature cn on cn.CUSTOMERNATUREID=sub.CUSTOMERNATURE
inner join mgznpostby mgzn on mgzn.mgznpostbyid=sub.mgznpostbyid
where sub.ISCANCEL is null and cn.ISITCOMPLEMENTARY=0 and sub.BILLSTATUS='Bill Generated'
and DATE_FORMAT(sub.toDate,'%Y-%m-%d')='2017-04-15' group by p.PARTYID

Time : 10:57:01
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
Raw SQL : select p.PARTYID,p.PARTYCODE,p.NAME,sub.AMOUNT,
sub.DISCOUNTAMOUNT,sub.totalAmt,
DATE_FORMAT(sub.BILLDATE,'%d %M %Y') as BILLDATE,
DATE_FORMAT(sub.fromDate,'%d %M %Y') as fromDate,
DATE_FORMAT(sub.toDate,'%d %M %Y') as toDate,cn.NATURE,mgzn.NAME as mgznpostvalue,
sub.BILLNO,csc.NAME as cityname,csc.CODE as filecode from subscription sub
inner join invoicedetail inv on inv.REFERENCENO=sub.BILLNO
inner join transaction t on t.TRANSACTIONID=inv.TRANSACTIONID
inner join mastertransaction mt on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID
inner join partydetail p on p.PARTYID=sub.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
inner join customernature cn on cn.CUSTOMERNATUREID=sub.CUSTOMERNATURE
inner join mgznpostby mgzn on mgzn.mgznpostbyid=sub.mgznpostbyid
where sub.ISCANCEL is null and cn.ISITCOMPLEMENTARY=0 and sub.BILLSTATUS='Bill Generated'
and DATE_FORMAT(sub.toDate,'%Y-%m-%d')='2017-04-15' group by p.PARTYID