Time : 09:55:47
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 ab.addresstype=c.addresstype  and FIRMNAME=17118 and COURIERCONAME=10383 and docketNo=ps order by DISPATCHDATE DESC

Time : 08:52:21
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 ab.addresstype=c.addresstype  and SUBJECTMASTER=192 and COURIERCONAME=10383 and docketNo=ps order by DISPATCHDATE DESC

Time : 08:51:48
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 ab.addresstype=c.addresstype  and COURIERCONAME=10383 and docketNo=ps and DISPATCHDATE BETWEEN  '2017-04-15 00:00:00' AND '2017-04-30 00:00:00' and ab.UPDATEDBY=31 order by DISPATCHDATE DESC

Time : 08:48:38
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 ab.addresstype=c.addresstype  and FIRMNAME=14353 and COURIERCONAME=10383 and docketNo=ps order by DISPATCHDATE DESC

Time : 08:44:44
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 ab.addresstype=c.addresstype  and COURIERCONAME=10383 and docketNo=ps order by DISPATCHDATE DESC

Time : 08:44:15
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 ab.addresstype=c.addresstype  and docketNo=ps order by DISPATCHDATE DESC

Time : 08:13:57
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 ab.addresstype=c.addresstype  and COURIERCONAME=14529 and docketNo=ps order by DISPATCHDATE DESC

Time : 08:11:59
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 ab.addresstype=c.addresstype  and COURIERCONAME=14529 and docketNo=ps order by DISPATCHDATE DESC

Time : 08:11:38
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 ab.addresstype=c.addresstype  and docketNo=ps order by DISPATCHDATE DESC

Time : 08:11:20
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 ab.addresstype=c.addresstype  and FIRMNAME=14664 and docketNo=ps order by DISPATCHDATE DESC

Time : 08:09:54
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 ab.addresstype=c.addresstype  and docketNo=ps order by DISPATCHDATE DESC

Time : 08:09:27
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 ab.addresstype=c.addresstype  and docketNo=ps order by DISPATCHDATE DESC