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 02/05/2012 11:03

SID LID Name Sex Lodged Release P.O.
13929986 24636 BEEBERGER, ALLEN JOSEPH MALE 12/30/2011 02/27/2012 (Not Assigned)
  Clock Status Docket Charge
  12/30/2011 13:01 PSANC 082804 UNLAWFUL USE OF A WEAPON
 
16958333 33074 BORDEN, NICHOLAS DEAN MALE 01/27/2012   (Not Assigned)
  Clock Status Docket Charge
  01/27/2012 16:50 PARVIO 16958333 PAROLE VIOLATION
 
12821079 22202 CASE, ERIN JAMES MALE 01/28/2012   (Not Assigned)
  Clock Status Docket Charge
  01/28/2012 07:02 SANCPEND 09-0632670 ROBBERY III
 
17421392 33236 DICKENSON, GEORGINA DANEEN FEMALE 01/31/2012   (Not Assigned)
  Clock Status Docket Charge
  01/31/2012 17:05 PROVIO 113172 POSSESSION METHAMPHETAMINE
  01/31/2012 17:05 PROVIO 113172 THEFT I
 
11886374 19396 JOHNSON, COURTNEY MICHAEL MALE 01/09/2012 02/08/2012 (Not Assigned)
  Clock Status Docket Charge
  01/09/2012 22:32 PSANC 102283 FELON IN POSSESSION OF A FIREARM
 
06585887 06785 NELSON, ARCHIE HUGH MALE 01/30/2012   (Not Assigned)
  Clock Status Docket Charge
  01/30/2012 02:26 PARVIO 06585887 PAROLE VIOLATION
 
15735974 33759 PETTIET, RODGER DALE MALE 01/31/2012   (Not Assigned)
  Clock Status Docket Charge
  01/31/2012 12:30 PARVIO 15735974 PAROLE VIOLATION
 
13137966 36764 RICHARDS, JOHN PAUL MALE 01/26/2012   (Not Assigned)
  Clock Status Docket Charge
  01/26/2012 12:30 PROVIO 112422 ASSAULT III
 
15099745 27730 RONEY, WILLIAM ALLEN MALE 01/05/2012 02/19/2012 (Not Assigned)
  Clock Status Docket Charge
  01/05/2012 14:00 PSANC 031963 SEX ABUSE I
 
7042929 16667 SCHAAD, SAMUEL LEE MALE 01/31/2012   (Not Assigned)
  Clock Status Docket Charge
  01/31/2012 10:29 PARVIO 7042929 PAROLE VIOLATION
 
08611914 16402 SIGLER, DAVID ALLAN MALE 02/03/2012   (Not Assigned)
  Clock Status Docket Charge
  02/03/2012 17:21 PARVIO 08611914 PAROLE VIOLATION
 
15529036 28703 SONDENAA, EDWIN DALE MALE 12/27/2011 02/10/2012 (Not Assigned)
  Clock Status Docket Charge
  12/27/2011 15:07 PSANC 034094 SEX ABUSE I
 
19217242 37096 TALBOT, DYLAN CRAIG MALE 01/26/2012   (Not Assigned)
  Clock Status Docket Charge
  01/26/2012 16:00 PROVIO 113825 POSSESSION METHAMPHETAMINE
 
13084046 22822 UPTON, AARON CHARLES MALE 01/31/2012   (Not Assigned)
  Clock Status Docket Charge
  01/31/2012 12:30 PARVIO 13084046 PAROLE VIOLATION
 
16795011 31822 VANHOOREBEKE, JOSHUA LOREN MALE 02/02/2012   (Not Assigned)
  Clock Status Docket Charge
  02/02/2012 17:05 PARVIO 16795011 PAROLE VIOLATION
  02/02/2012 17:05 PROVIO 113799 POSSESSION METHAMPHETAMINE
 
17857325 34179 WILLIAMSON, MARY ELIZABETH FEMALE 01/29/2012 02/08/2012 (Not Assigned)
  Clock Status Docket Charge
  01/29/2012 04:52 POSANC 103228 ASSAULT II ATTEMPT
 
13536500 23810 WILSON, CONNIE LYNETTE FEMALE 02/01/2012   (Not Assigned)
  Clock Status Docket Charge
  02/01/2012 15:45 SANCPEND 080209 DELIVERY METHAMPHETAMINE
 
Total Inmates: 17