Bug in Power BI

[bobbyd]

I have a report which gives inaccurate totals if I add a filter on an aggregated column for "is not blank".  Now, there are no records in the data that have "Sum of L8_TOTAL_NET_RECEIPTS" of null.  

Here's the table with no filter added for the L8_TOTAL_NET_RECEIPTS column.

The highlighted row will disappear if I add a filter on the "Sum of L8_TOTAL_NET_RECEIPTS" is not blank.

There should be no difference in adding that filter.  As you can see, the totals are now incorrect.  One row has been dropped.  The highlighted row in the first pic is missing from the second pic.

I'm finding way too many bugs in this product for it to be useful.

Bob

[amitchandak]

@bobbyd , I doubt that can happen. Please sort on that column and check for blank.

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[bobbyd]

There are no blanks.  I found the issue.  This is a "Direct Query" dataset.  And Power BI is case insensitive, but the data in the database is case sensitive.  So, when the tool is building the query and adding in all the individual filtered rows (which I don't understand why it needs to do that), it uses "Our Lady Of Guadalupe Church" and the data in the database for this particular license is "Our Lady of Guadalupe Church".  This problem tells me I cannot use Direct Query anymore.  It produces inaccurate results due to case sensitivity issues.

[bobbyd]

As soon as you add a filter on an aggregated column, it builds a sql query with all the individual rows added into the where clause (not sure why it has to do that!).  I've attached the query and you can see it built "Our Lady Of Guadalupe Church" into the where clause for a particular license where the name is slightly different for that license in the database, so it dropped out of the result set.

SELECT
*
FROM 
(

SELECT
"t2"."UNIT_ID" "c167","t2"."LICENSE_ID" "c168","t2"."ORGANIZATION_NAME" "c170", SUM ( "t1"."QTR_REPORTS" )
 "a0", SUM ( "t1"."L8_TOTAL_NET_RECEIPTS" )
 "a1"
FROM 
(
(
(
(

SELECT
"DIM_BINGO_QTR_ID","DIM_BINGO_ORG_ID","DIM_BINGO_QR_CODE_ID",
CAST("QTR_REPORTS" as NUMBER(19, 0))
 "QTR_REPORTS","L8_TOTAL_NET_RECEIPTS"
FROM 
(
(
select 
LIC_UNIT_ID, FILING_PERIOD, DUE_DATE, DIM_BINGO_QTR_ID, DIM_BINGO_ORG_ID, 
 DIM_BINGO_QR_CODE_ID, DIM_BINGO_PHYLOC_ID, DIM_BINGO_QTRLOC_ID, QTR_REPORTS, ORIGINAL_POSTMARK_DATE, 
 POSTMARK_DATE, DAYS_FILED_LATE, QRMD_TOTAL_SALES_EQUIPMENT, QRMD_TOTAL_SALES_CARDS, QRMD_TOTAL_SALES_INSTANT, 
 QRMD_TOTAL_SALES, QRMD_TOTAL_LEASE, QRL_L1A_RENT_INCOME_PRIOR, QRL_L1A_RENT_INCOME_ON_AFTER, QRL_L1_TOTAL_RENT_INCOME, 
 QRL_L2_TAX_RATE, QRL_L2_TAXABLE_DUE, QRL_L3_LATE_FILING_PENALTY, QRL_L4_LATE_FILING_INTEREST, QRL_L5_TOTAL_AMOUNT_DUE, 
 QRL_L6_TAX_UTIL_INS_COLLECTED, QRL_L7_TAX_UTIL_INS_PAID, QRL_RR_TOTAL_ORGS, QRL_RR_TOTAL_OCCASIONS, QRL_RR_TOTAL_RENT_RECEIVED, 
 QRL_RR_RENT_PER_OCCASION, L1_OCCASIONS, L2_PERSONS_ATTENDING, 
 CAST(L3_CARD_SALE_ENTRANCE_FEE AS NUMBER(12,2)) L3_CARD_SALE_ENTRANCE_FEE,
 L3_REGULAR_PRIZES_OVER_FIFTY, 
 L4_ELECTRONIC_CARD_SALES, L4_REG_PRIZES_FIFTY_OR_LESS, L5_GROSS_RCPTS_REGULAR_CARDS, L5_REGULAR_PRIZES, L5_NET_RECEIPTS_CARD, 
 L6_GROSS_RCPTS_PULLTAB_EVENT, L6_PRIZES_AWD_PULLTAB_EVENT, L6_NET_RECEIPTS_PULLTAB_EVENT, L7_GROSS_RCPT_PULLTAB_INSTANT, L7_PRIZES_AWD_PULLTAB_INSTANT, 
 L7_NET_RCPTS_PULLTAB_INSTANT, L8_GROSS_RECEIPTS, L8_TOTAL_BINGO_PRIZES, L8_TOTAL_NET_RECEIPTS, L8A_TOTAL_PRIZES_LESS_FIVE, 
 L8B_PRIZES_SUBJECT_TO_FEE, L9B_RENT_INCOME_TAXED, L9C_RENT_INCOME_NON_TAXED, L9_TOTAL_RENT_INCOME, L10_TAX_UTIL_INS_RECEIVED, 
 L11A_INTEREST_EARNED, L11B_UNCLAIMED_CUSTOMER_FUNDS, L11C_EQUIPMENT_SUPPLIES_SALES, L11_TOTAL_OTHER_INCOME, L12_TOTAL_PROCEEDS, 
 L13_RENT_PAYMENTS, L14_TAX_UTIL_PAID_TO_LESSOR, L15_TOTAL_RENT_PAYMENTS, L16_COST_GOODS_REGULAR_PAPER, L16_COST_GOODS_REG_ELECTRON, 
 L16_COST_GOODS_REGULAR, L17_COST_GOODS_PULLTAB_EVENT, L17_COST_GOODS_PULLTAB_INST, L17_COST_GOODS_PULLTAB, L18_BINGO_EQUIPMENT_EXPENSE, 
 L19_RENTAL_TAX, L20_ADVERTISING_EXPENSE, L21_PREMISES_EXPENSES, L22_SECURITY_LEGAL_ACCTG_EXP, L23_EMPLOYEE_EXPENSES, 
 L24_LICENSE_FEES_EXPENSE, L25_OTHER_EXPENSES, L26_TOTAL_EXPENSES, L27_TOTAL_EXPENSE_PAYMENTS, L28_PRIZE_FEE_PAID, 
 L28_PRIZE_FEE_WITHHELD, L28_TOTAL_PRIZE_FEES, L29_NET_PROCEEDS_THIS_QUARTER, L30A_CHARITABLE_DISTRIBUTION, L30B_UNCLAIMED_CUSTOMER_FUNDS, 
 L30_TOTAL_DISTRIBUTIONS, REQUIRED_DISTRIBUTION, L31_NONBINGO_FUNDS_RECEIVED, L31_NONBINGO_FUNDS_REIMBURSED, L31_TRANSFER_NONBINGO_FUNDS, 
 L32_BINGO_FUNDS_RECEIVED, L32_BINGO_FUNDS_REIMBURSED, L32_TRANSFER_OF_BINGO_FUNDS, L33_PREV_PROCEED_UNDISTRIB, L34_TOTAL_OTHER_TRANSACTIONS, 
 L35_BINGO_FUNDS_BAL_PERBOOK, L36_CHECKING_ACCOUNT_BALANCE, L37_DEPOSITS_INTRANSIT, L38_OUTSTANDING_CHECKS, L39_RECONCILED_BANK_BALANCE, 
 L40_RECONCILED_SAVINGS_ACCT, L41_CASH_ON_HAND, L42_BINGO_FUNDS_BALANCE, L1A_TAXABLE_AMOUNT, L2A_PRIZE_FEE_RATE, 
 L3A_TAXABLE_DUE, L4A_LATE_FILING_PENALTY, L5A_LATE_FILING_INTEREST, L6A_TOTAL_DUE, L7A_RENT_INCOME, 
 L8A_RENTAL_TAX_RATE, L9A_RENTAL_TAX_DUE, L10A_LESSOR_LATE_FILING_PEN, L11A_LESSOR_LATE_FILING_INT, L12A_RENTAL_TAXTOTAL, 
 L13A_TOTAL_DUE_W_RENTAL_TAX, OPERATING_CAPITAL_LIMIT, REGULAR_BINGO_SALES, PULL_TAB_TICKET_SALES, PULL_TAB_TICKET_PRIZES, 
 BINGO_PRIZES, RENTAL_INCOME_INCL_TAXES, NET_RECEIPTS, TOTAL_INCOME, RENT_PAYMENTS_INCL_TAXES, 
 COST_OF_GOODS_SOLD_TTL, PREMESIS_EXPENSES, TOTAL_EXPENSES_ALL, CHARITABLE_AMT, RELIGIOUS_AMT, 
 EDUCATION_AMT, EXEMPT_SOCIAL_AMT, EXEMPT_EXPENSES_AMT, POLITICAL_AMT, FUTURE_CHARITABLE_AMT, 
 UNIT_SUM_MEMBER_OCCASIONS, UNIT_SUM_UNIT_AMOUNT_TRANSFRD, UNIT_SUM_TRANSFER_FUNDS_RECVD, UNIT_SUM_TRANSFER_FUNDS_REIMB, UNIT_SUM_NET_PROCD_CONTR_RECVD, 
 --UNIT_SUM_CHAR_DIST_FROM_UNIT, 
 --UNIT_SUM_CHAR_DIST_TO_CHARITY, 
 --UNIT_SUM_CHAR_DIST_TO_RELIGS, 
 --UNIT_SUM_CHAR_DIST_TO_EDUCATN, 
 --UNIT_SUM_CHAR_DIST_TO_SOCIAL, 
 --UNIT_SUM_CHAR_DIST_TO_ADMIN, 
 --UNIT_SUM_CHAR_DIST_TO_POLITCAL, 
 AU_COND_MEMBER_OCCASIONS, AU_COND_UNIT_AMT_TRANSF, AU_COND_TRNSF_FUNDS_RECVD, 
 AU_COND_TRNSF_FUNDS_REIMB, AU_COND_NET_PRCD_CONTRB_RECVD, AU_COND_CHAR_DIST_FROM_UNIT, 
 --AU_COND_CHAR_DIST_TO_CHARITY, 
 --AU_COND_CHAR_DIST_TO_RELIG, 
 --AU_COND_CHAR_DIST_TO_EDUCATN, 
 --AU_COND_CHAR_DIST_TO_SOCIAL, 
 --AU_COND_CHAR_DIST_TO_ADMIN, 
 --AU_COND_CHAR_DIST_TO_POLITCL, 
 LSR_REPORTED_OCCASIONS, 
 LSR_REPORTED_RENT, MD_RPT_TOTAL_SALES_EQUIPMENT, MD_RPT_TOTAL_SALES_CARD, MD_RPT_TOTAL_SALES_INSTANT, MD_RPT_TOTAL_SALES, 
 MD_RPT_TOTAL_LEASE
from jspr_fact_bingo_qtr_reports_vw
)
)
 "t1"
)
 "t1"

 INNER JOIN 

(
select 
  DIM_BINGO_QTR_ID,
  FILING_PERIOD,   
  CAL_YEAR,        
  CAL_QTR,         
  DUE_DATE,        
  QTR_BEGIN_DATE,  
  QTR_END_DATE    
from jspr_dim_bingo_qtrs_vw
) "t0" on 
(
"t1"."DIM_BINGO_QTR_ID" = "t0"."DIM_BINGO_QTR_ID"
)
)


 INNER JOIN 

(

SELECT
"DIM_BINGO_ORG_ID",
CAST("UNIT_ID" as NUMBER(19, 0))
 "UNIT_ID",
CAST("LICENSE_ID" as NUMBER(19, 0))
 "LICENSE_ID","ORGANIZATION_TYPE","ORGANIZATION_NAME"
FROM 
(
(
select DIM_BINGO_ORG_ID, LIC_UNIT_ID, ORG_UNIT_ID, ORGANIZATION_ID, CAST(UNIT_ID AS NUMBER(15,0)) UNIT_ID, 
 CAST(LICENSE_ID AS NUMBER(15,0)) LICENSE_ID, ORGANIZATION_TYPE, TRIM(ORGANIZATION_NAME) ORGANIZATION_NAME, TAXPAYER_NUMBER, TAXPAYER_NUMBER_REDACTED, 
 LICENSE_UNIT_STATUS, LICENSE_TYPE, LOCATION_TYPE, NON_PROFIT_TYPE, CHARITABLE_TYPE, 
 TYPE_501C, ADMIN_HOLD_STATUS, BUSINESS_PHONE, STREET_ADDRESS, ADDRESS_CITY, 
 ADDRESS_STATE, ADDRESS_ZIP, CONTACT_NAME, CONTACT_EMAIL_ADDRESS, CONTACT_PHONE_NUMBER, 
 CHAIRP_DESAGNT_LAST_NAME, CHAIRP_DESAGNT_FIRST_NAME, CHAIRP_DESAGNT_MIDDLE_INITIAL, CHAIRP_DESAGNT_FULLNAME_FML, CHAIRP_DESAGNT_FULLNAME_LMF, 
 CHAIRP_DESAGNT_PHONE_NUMBER, CHAIRP_DESAGNT_EMAIL_ADDRESS
 from jspr_dim_bingo_orgs_vw
)
)
 "t2"
)
 "t2" on 
(
"t1"."DIM_BINGO_ORG_ID" = "t2"."DIM_BINGO_ORG_ID"
)
)


 INNER JOIN 

(
select
DIM_BINGO_QR_CODE_ID, FILING_STATUS, FILING_METHOD, TIMELY_STATUS, REPORT_TYPE, 
 LESSOR_FILED_BY, CHARITABLE_DIST_FILING_STATUS, CHARITABLE_DIST_FILING_METHOD, LESSOR_RR_FILING_STATUS, LESSOR_RR_FILING_METHOD, 
 AU_CHAR_DIST_FILING_STATUS, AU_COND_REPORTING_UNIT, LSR_REPORTED_REPORTING_LESSOR
 from jspr_dim_bingo_qr_codes_vw
) "t3" on 
(
"t1"."DIM_BINGO_QR_CODE_ID" = "t3"."DIM_BINGO_QR_CODE_ID"
)
)

WHERE 
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t3"."FILING_STATUS" = 'Filed'
)
)
 AND 
(
(
(SELECT INSTR(Op2, Op1, Op3) FROM (SELECT UPPER('O') AS Op1, UPPER("t2"."ORGANIZATION_NAME") AS Op2, 1 AS Op3 FROM DUAL) AuxTable)
 = 1)
 AND 
(
("t2"."ORGANIZATION_TYPE" IN ('Conductor','Non-Regular Conductor','Unit'))
)
)
)
 AND 
(
(
(
(
(
(
(
(
(
"t2"."LICENSE_ID" = 117602
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Church'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 117898
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Church'
)
)
)
 OR 
(
(
(
(
"t2"."LICENSE_ID" = 118191
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of The Angels Catholic Church'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 1871
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of The Rosary Catholic Church'
)
)
)
)
 OR 
(
(
(
(
(
"t2"."LICENSE_ID" = 1492
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Catholic Church'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 237099
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady of Perpetual Help Catholic School'
)
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 238152
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Outreach United'
)
)
)
)
 OR 
(
(
(
(
(
"t2"."LICENSE_ID" = 244332
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Operation Phantom Support Inc'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 3469
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Refuge Catholic Church'
)
)
)
 OR 
(
(
(
(
"t2"."LICENSE_ID" = 117121
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Parish & Shrine'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 261044
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Church'
)
)
)
)
)
 OR 
(
(
(
(
(
(
"t2"."LICENSE_ID" = 212626
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady of Grace Academy'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 117556
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Queen Of Heaven Catholic Church'
)
)
)
 OR 
(
(
(
(
"t2"."LICENSE_ID" = 117677
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Queen Of Peace Catholic Church'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" IS NULL 
)
 AND 
(
"t2"."UNIT_ID" = 562
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Oasis Bingo Unit Trust'
)
)
)
)
 OR 
(
(
(
(
(
"t2"."LICENSE_ID" = 1212
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Order Of The Alhambra Alva Caravan #91'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 2769
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Odessa Westside Lions Club'
)
)
)
 OR 
(
(
(
(
"t2"."LICENSE_ID" = 117236
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Consolation Catholic Church'
)
)
 OR 
(
(
(
"t2"."LICENSE_ID" = 118046
)
 AND 
(
"t2"."UNIT_ID" IS NULL 
)
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Good Counsel Church'
)
)
)
)
)
)
 AND 
(
(
(
(
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 117602
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Church'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 117898
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Church'
)
)
)
)
 OR 
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 118191
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of The Angels Catholic Church'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 1871
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of The Rosary Catholic Church'
)
)
)
)
)
 OR 
(
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 1492
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Catholic Church'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 237099
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady of Perpetual Help Catholic School'
)
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 238152
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Outreach United'
)
)
)
)
)
 OR 
(
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 244332
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Operation Phantom Support Inc'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 3469
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Refuge Catholic Church'
)
)
)
)
 OR 
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 117121
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Parish & Shrine'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 261044
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Guadalupe Church'
)
)
)
)
)
)
 OR 
(
(
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 212626
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady of Grace Academy'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 117556
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Queen Of Heaven Catholic Church'
)
)
)
)
 OR 
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 117677
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Queen Of Peace Catholic Church'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" IS NULL 
)
)
 AND 
(
(
"t2"."UNIT_ID" = 562
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Oasis Bingo Unit Trust'
)
)
)
)
)
 OR 
(
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 1212
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Order Of The Alhambra Alva Caravan #91'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 2769
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Odessa Westside Lions Club'
)
)
)
)
 OR 
(
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 117236
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Consolation Catholic Church'
)
)
)
 OR 
(
(
(
"t0"."FILING_PERIOD" = '20224'
)
 AND 
(
"t2"."LICENSE_ID" = 118046
)
)
 AND 
(
(
"t2"."UNIT_ID" IS NULL 
)
 AND 
(
"t2"."ORGANIZATION_NAME" = 'Our Lady Of Good Counsel Church'
)
)
)
)
)
)
)
)
)

GROUP BY "t2"."UNIT_ID","t2"."LICENSE_ID","t2"."ORGANIZATION_NAME"
)
 "MainTable"
WHERE 
(

NOT(
(
"a0" IS NULL 
)
)
 OR 
NOT(
(
"a1" IS NULL 
)
)

)