select distinct oc1.offender, j.oname, j.sid, j.lid, j.sex, j.lodged, j.maxrelease, e.aname from openclocksview oc1, jailhouseview j, offenders o left outer join employees e on e.employee=o.poemployee where oc1.offender=j.offender and oc1.offender=o.offender and oc1.facility='LINCOL_OR' and oc1.clockin in ('ARRPROB','PSANC','POSANC','PARVIO','PROVIO', 'SANCPEND') and (select count(*) from openclocksview oc2 where oc2.offender=oc1.offender and oc2.clockin not in ('ARRPROB','PSANC','POSANC','PARVIO','PROVIO', 'SANCPEND')) = 0 order by j.oname

P&P only Inmates for Lincoln County
as of 03/10/2010 00:02

SID LID Name Sex Lodged Release P.O.
08256596 21764 BARNES, KIMBERLY ANN FEMALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 09:46 PARVIO 8256596 PAROLE VIOLATION
 
16958333 33074 BORDEN, NICHOLAS DEAN MALE 02/25/2010 04/26/2010 (Not Assigned)
  Clock Status Docket Charge
  02/25/2010 13:24 PSANC 16958333 PAROLE VIOLATION
 
12511495 29085 DOROUGH, NATHAN MICHAEL MALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 12:59 PSANC 12511495 PAROLE VIOLATION
 
16257882 30440 GEORGIYEV, RUSLAN EDUAROVICH MALE 03/04/2010   (Not Assigned)
  Clock Status Docket Charge
  03/04/2010 10:12 PROVIO 055489 DISORDERLY CONDUCT
 
16956278 35325 GETTY, ANTHONY LOWELL MALE 03/03/2010   (Not Assigned)
  Clock Status Docket Charge
  03/03/2010 10:28 SANCPEND 16956278 PAROLE VIOLATION
 
12737722 22032 GODDARD, RICHARD WILLIAM MALE 03/07/2010 03/27/2010 (Not Assigned)
  Clock Status Docket Charge
  03/07/2010 11:32 PSANC 12737722 PAROLE VIOLATION
 
16757199 31708 GOODELL, AMBER DAWN FEMALE 03/02/2010   (Not Assigned)
  Clock Status Docket Charge
  03/02/2010 23:02 PROVIO 081503 BURGLARY I
  03/02/2010 23:02 PROVIO 081503 THEFT III
  03/02/2010 23:02 PROVIO 072486 POSSESSION METHAMPHETAMINE
  03/02/2010 23:02 PROVIO 072486 CRIM MISCHIEF II
 
13617267 23957 HATFIELD, MELISSA BETH FEMALE 03/04/2010 03/11/2010 (Not Assigned)
  Clock Status Docket Charge
  03/04/2010 10:02 POSANC 084572 UNLAWFUL USE OF A WEAPON
 
14906769 27274 HAUSMANN, JEFFREY JOHN MALE 03/07/2010   (Not Assigned)
  Clock Status Docket Charge
  03/08/2010 10:43 PROVIO 090843 POSS CONTROL SUB - SCH II
 
08314885 13059 MORTON, GLEN LEON MALE 03/05/2010   (Not Assigned)
  Clock Status Docket Charge
  03/05/2010 20:01 PARVIO 073312 POSS CONTROL SUB - SCH II
 
08872783 33631 NEWHOUSE, MICHAEL VERNON MALE 03/03/2010   (Not Assigned)
  Clock Status Docket Charge
  03/03/2010 14:35 PARVIO 08872783 PAROLE VIOLATION
 
17573947 33566 POLELLO, KELLI SUE FEMALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 09:59 ARRPROB 091115 POSSESSION METHAMPHETAMINE
 
05888073 12408 REED, JAMES PATRICK MALE 02/18/2010   (Not Assigned)
  Clock Status Docket Charge
  02/18/2010 12:35 SANCPEND 05888073 PAROLE VIOLATION
 
05932358 03818 SHORT, JAMES PATRICK MALE 02/12/2010 03/18/2010 LONG T
  Clock Status Docket Charge
  02/12/2010 12:18 PSANC 05932358 PAROLE VIOLATION
 
08611914 16402 SIGLER, DAVID ALLAN MALE 02/19/2010 04/19/2010 (Not Assigned)
  Clock Status Docket Charge
  02/19/2010 22:24 PSANC 08611914 PAROLE VIOLATION
 
15529036 28703 SONDENAA, EDWIN DALE MALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 13:48 PROVIO 15529036 PAROLE VIOLATION
 
15869243 29846 THOMAS, SHANNON URETTA FEMALE 03/02/2010 03/12/2010 (Not Assigned)
  Clock Status Docket Charge
  03/02/2010 10:29 POSANC 080230632 POSSESSION METHAMPHETAMINE
 
11963542 19905 WEDDLE, GUY ROBERT MALE 09/30/2009 10/29/2009 (Not Assigned)
  Clock Status Docket Charge
  03/03/2010 16:30 PARVIO 11963542 PAROLE VIOLATION
 
07779443 30459 WILLIAMS, MARK EDWARD MALE 02/22/2010 04/22/2010 (Not Assigned)
  Clock Status Docket Charge
  02/22/2010 09:10 PSANC 07779443 PAROLE VIOLATION
 
06834711 07685 WOOLEY, TROY LEE MALE 02/03/2010 04/03/2010 (Not Assigned)
  Clock Status Docket Charge
  02/03/2010 14:30 PSANC 06834711 PAROLE VIOLATION
 
14617435 32409 YOUNG, DONALD JAMES MALE 03/06/2010   (Not Assigned)
  Clock Status Docket Charge
  03/06/2010 10:12 SANCPEND 073823 POSSESSION METHAMPHETAMINE
 
Total Inmates: 21