Standard WHEREs

INSPECTIONS

"G6ACTION"."G6_COMPL_DD" IS  NOT  NULL
    AND "G6ACTION"."G6_STATUS_DD" IS  NOT  NULL     AND "G6ACTION".REC_STATUS = 'A'
    AND B1_ALT_ID NOT LIKE '%vncy%'
    AND B1PERMIT."REC_STATUS" = 'A'     AND (
(
B1PERMIT.b1_appl_status <> 'cancelled'
AND B1PERMIT.b1_appl_status <> 'Classified Abandon'
)
OR (B1PERMIT.b1_appl_status IS NULL)
)
AND (
(
isnull(B1PERMIT.B1_APPL_CLASS,'') NOT IN (
'INCOMPLETE EST'
,'INCOMPLETE TMP'
)
)
OR (B1PERMIT.B1_APPL_CLASS IS NULL)
)
AND "G6ACTION"."G6_STATUS" NOT IN ('DPWR','Pending','Scheduled','Rescheduled','Cancelled')
AND "G6ACTION"."INSP_GROUP" != 'AATRAINING'
AND (b1_per_group = 'building' OR b1_per_group = 'Enforcement')
AND b1_per_sub_type != 'health'
AND "G6ACTION"."GA_FNAME" + ' ' + "G6ACTION"."GA_LNAME" != 'Steve Desilets'
AND "G6ACTION"."GA_FNAME" + ' ' + "G6ACTION"."GA_LNAME" != 'David Cotter'
AND "G6ACTION"."GA_FNAME" + ' ' + "G6ACTION"."GA_LNAME" != 'Admin Admin'
AND G6ACTION.G6_COMPL_DD >= @StartDate
AND G6ACTION.G6_COMPL_DD < DATEADD(day,1,@EndDate) 

AND B1P.b1_alt_id NOT LIKE '%tmp%'