Time : 13:33:25
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ps' in 'where clause'
Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact group by PARTY) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty  and docketNo=ps and ab.UPDATEDBY=2 order by DISPATCHDATE DESC

Time : 13:30:10
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ps' in 'where clause'
Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact group by PARTY) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty  and docketNo=ps order by DISPATCHDATE DESC

Time : 13:25:02
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ps' in 'where clause'
Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact group by PARTY) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty  and docketNo=ps order by DISPATCHDATE DESC

Time : 13:17:43
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ds' in 'where clause'
Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact group by PARTY) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty  and docketNo=ds and DISPATCHDATE BETWEEN  '2017-06-01 00:00:00' AND '2017-06-30 00:00:00' order by DISPATCHDATE DESC