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') and (select count(*) from openclocksview oc2 where oc2.offender=oc1.offender and oc2.clockin not in ('ARRPROB','PSANC','POSANC','PARVIO','PROVIO')) = 0 order by j.oname

P&P only Inmates for Lincoln County
as of 01/07/2009 06:01

SID LID Name Sex Lodged Release P.O.
05636361 02273 ADKINS, MELVIN LEE MALE 01/06/2009   (Not Assigned)
  Clock Status Docket Charge
  01/06/2009 13:33 ARRPROB 034231 DRIVE UNDER INFLUENCE INTOX
 
13637096 30005 ANDERSON, CLIFTON RAY MALE 01/04/2009 01/14/2009 (Not Assigned)
  Clock Status Docket Charge
  01/04/2009 04:15 PSANC 13637096 PAROLE VIOLATION
 
13293155 24769 ATKINSON, DON LEE MALE 12/23/2008   (Not Assigned)
  Clock Status Docket Charge
  12/23/2008 14:22 PARVIO 13293155 PAROLE VIOLATION
 
13929986 24636 BEEBERGER, ALLEN JOSEPH MALE 12/28/2008 01/27/2009 (Not Assigned)
  Clock Status Docket Charge
  12/28/2008 15:45 POSANC 082804 UNLAWFUL USE OF A WEAPON
 
11484740 18804 BROWN, JASON MICHAEL MALE 01/02/2009 01/08/2009 (Not Assigned)
  Clock Status Docket Charge
  01/02/2009 16:47 POSANC 073322 ASSAULT IV DOMESTIC VIOLENCE
 
10563013 25694 BRUNELLE, ROBERT JOSEPH MALE 12/24/2008 02/21/2009 (Not Assigned)
  Clock Status Docket Charge
  12/24/2008 10:18 PSANC 10563013 PAROLE VIOLATION
 
15852587 29597 CADWELL, JOHN MICHAEL MALE 12/05/2008   (Not Assigned)
  Clock Status Docket Charge
  12/05/2008 17:35 PROVIO 080498 POSSESSION COCAINE
 
15374312 28333 DAVIDSON, KENNETH ALFRED MALE 12/30/2008 01/29/2009 (Not Assigned)
  Clock Status Docket Charge
  12/30/2008 11:48 PSANC 15374312 PAROLE VIOLATION
 
14660970 30881 DUNMIRE, JARED LAWRENCE MALE 12/11/2008   (Not Assigned)
  Clock Status Docket Charge
  12/12/2008 16:28 PROVIO 071079 UNAUTHORIZED USE VEHICLE
 
02966059 27244 HEWITT, DANIEL AVERON MALE 01/05/2009   (Not Assigned)
  Clock Status Docket Charge
  01/05/2009 10:59 PARVIO 02966059 PAROLE VIOLATION
 
15590305 28874 HITT, JEFFERY STEPHEN MALE 10/17/2008 01/15/2009 (Not Assigned)
  Clock Status Docket Charge
  10/17/2008 11:43 PSANC 15590305 PAROLE VIOLATION
 
14608427 26459 HOUX, TRAVIS ALLEN MALE 12/26/2008 01/15/2009 (Not Assigned)
  Clock Status Docket Charge
  12/26/2008 09:45 POSANC 072964 POSS CONTROL SUB - SCH II
 
05081479 01818 KEFFER, CHARLES BENTON MALE 11/12/2008 01/10/2009 (Not Assigned)
  Clock Status Docket Charge
  11/12/2008 11:40 PSANC 05081479 PAROLE VIOLATION
 
15558220 33550 KELLAND, BROCK MATHEWS MALE 01/02/2009 01/16/2009 (Not Assigned)
  Clock Status Docket Charge
  01/02/2009 21:35 POSANC CR0701720 POSSESSION METHYLENEDIOXYMETH
 
14848756 29318 KELSO, JEREMY LEE MALE 01/06/2009   (Not Assigned)
  Clock Status Docket Charge
  01/06/2009 12:49 PARVIO null PAROLE VIOLATION
 
12554029 31790 KEPHART, JESSE LYNN MALE 12/23/2008 01/16/2009 (Not Assigned)
  Clock Status Docket Charge
  12/23/2008 12:50 PSANC 12554029 PAROLE VIOLATION
 
13714166 24133 MOFFATT, JONATHAN DEAN MALE 12/11/2008 01/24/2009 (Not Assigned)
  Clock Status Docket Charge
  12/11/2008 16:50 PSANC 13714166 PAROLE VIOLATION
 
07740507 26633 STAUSS, CHRIS ANTHONY MALE 12/05/2008 01/07/2009 (Not Assigned)
  Clock Status Docket Charge
  12/08/2008 13:14 POSANC 044017 MENACING
 
12530411 20936 STEPHEN, JAMES DARRYL SR MALE 11/10/2008 01/08/2009 (Not Assigned)
  Clock Status Docket Charge
  11/10/2008 16:30 PSANC 12530411 PAROLE VIOLATION
 
28679 28679 STRINGER, DAVID YOUNG JR MALE 12/31/2008 01/14/2009 (Not Assigned)
  Clock Status Docket Charge
  12/31/2008 09:46 POSANC 070588 CRIM MISTREATMENT I
 
16129605 31835 TIGHE, STEPHANIE MARIE FEMALE 01/05/2009   (Not Assigned)
  Clock Status Docket Charge
  01/05/2009 15:14 PROVIO 070716 CHILD NEGLECT
  01/05/2009 15:14 PROVIO 070716 DELIVERY METHAMPHETAMINE
 
15146057 27797 WATKINS, AETHENA CHRISTINE FEMALE 12/29/2008 01/28/2009 (Not Assigned)
  Clock Status Docket Charge
  12/29/2008 16:51 POSANC 083900 POSSESSION METHAMPHETAMINE
 
Total Inmates: 22