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 09/09/2010 05:02

SID LID Name Sex Lodged Release P.O.
15376845 35496 ANDERSON, JAMES LOREN MALE 09/02/2010 09/19/2010 (Not Assigned)
  Clock Status Docket Charge
  09/02/2010 21:46 POSANC 101610 THEFT I
 
06622428 06925 ANDERSON, KEVIN WAYNE MALE 08/24/2010   (Not Assigned)
  Clock Status Docket Charge
  08/24/2010 07:23 PARVIO 06622428 PAROLE VIOLATION
 
05652236 02246 BREON, MARK LEWIS MALE 09/03/2010   (Not Assigned)
  Clock Status Docket Charge
  09/03/2010 21:49 PROVIO 072976 POSSESSION METHAMPHETAMINE
  09/03/2010 21:49 PROVIO 072768 POSSESSION METHAMPHETAMINE
  09/03/2010 21:49 PROVIO 072581 CRIM MISCHIEF II
 
17306877 34470 BROWN, JORDAN ROBERT MALE 09/03/2010   (Not Assigned)
  Clock Status Docket Charge
  09/07/2010 16:00 SANCPEND 094785 DELIVERY MARIJUANA W/IN 1000 SCHOOL
 
17674384 33808 DIEHL, SARAH JEAN FEMALE 09/07/2010   (Not Assigned)
  Clock Status Docket Charge
  09/07/2010 16:13 SANCPEND 084877 POSSESSION HEROIN
 
06760027 33326 GREEN, DAVID LEE MALE 08/13/2010 09/11/2010 (Not Assigned)
  Clock Status Docket Charge
  08/13/2010 09:00 PSANC 06760027 PAROLE VIOLATION
 
04555703 08327 HARRINGTON, DAVID SCOTT MALE 08/22/2010 09/10/2010 (Not Assigned)
  Clock Status Docket Charge
  08/22/2010 18:33 PSANC 04555703 PAROLE VIOLATION
 
18153106 34834 ISON, KATELYNN MICHELLE FEMALE 09/08/2010   (Not Assigned)
  Clock Status Docket Charge
  09/08/2010 17:30 ARRPROB 101552 THEFT I
 
13639568 27425 LACROIX, JOSEPH DOUGLAS MALE 08/17/2010 10/15/2010 (Not Assigned)
  Clock Status Docket Charge
  08/17/2010 16:50 PSANC 13639568 PAROLE VIOLATION
 
12936889 28709 NICKERSON, NATHAN LEE MALE 08/24/2010   (Not Assigned)
  Clock Status Docket Charge
  08/24/2010 22:57 SANCPEND 12936889 PAROLE VIOLATION
 
16830782 31936 RODRIGUEZ-AGUILAR, JOSE FREDDY MALE 08/16/2010 09/14/2010 (Not Assigned)
  Clock Status Docket Charge
  08/16/2010 14:50 PSANC 16830782 PAROLE VIOLATION
 
16473104 30998 SCHAD, DEELANE ANN FEMALE 06/12/2010 09/09/2010 (Not Assigned)
  Clock Status Docket Charge
  06/12/2010 17:48 PSANC 16473104 PAROLE VIOLATION
  06/12/2010 17:48 PARVIO 16473104 PAROLE VIOLATION
 
16851236 32888 SMITH, RAYMOND JOSEPH MALE 09/02/2010 10/11/2010 (Not Assigned)
  Clock Status Docket Charge
  09/02/2010 12:10 PSANC 16851236 PAROLE VIOLATION
 
14989440 27473 SOYSTER, JOSEPH NORMAN MALE 08/16/2010   (Not Assigned)
  Clock Status Docket Charge
  08/16/2010 09:05 PARVIO 14989440 PAROLE VIOLATION
 
13197307 32864 SUCHODOLSKI, MARK ALAN MALE 09/05/2010   (Not Assigned)
  Clock Status Docket Charge
  09/05/2010 21:33 PROVIO 080128 DELIVERY METHAMPHETAMINE
 
07373728 09790 WAGNER, KENNETH SHERIDAN MALE 08/31/2010 09/25/2010 (Not Assigned)
  Clock Status Docket Charge
  08/31/2010 12:30 PSANC 07373728 PAROLE VIOLATION
 
16335008 30643 WHITE, CHRISTOPHER MICHAEL MALE 08/13/2010 09/12/2010 OTOOLE S
  Clock Status Docket Charge
  08/13/2010 12:07 PSANC 16335008 PAROLE VIOLATION
 
07779443 30459 WILLIAMS, MARK EDWARD MALE 09/04/2010   (Not Assigned)
  Clock Status Docket Charge
  09/04/2010 00:45 PARVIO 7779443 PAROLE VIOLATION
 
06834711 07685 WOOLEY, TROY LEE MALE 08/26/2010 09/14/2010 (Not Assigned)
  Clock Status Docket Charge
  08/26/2010 08:45 PSANC 06834711 PAROLE VIOLATION
 
Total Inmates: 19