Tan pronto como agrega un filtro en una columna agregada, crea una consulta sql con todas las filas individuales agregadas en la cláusula where (¡no estoy seguro de por qué tiene que hacer eso!). He adjuntado la consulta y puede ver que construyó "Iglesia de Nuestra Señora de Guadalupe" en la cláusula where para una licencia en particular donde el nombre es ligeramente diferente para esa licencia en la base de datos, por lo que se eliminó del conjunto de resultados.
ESCOGER
*
DE
(
ESCOGER
"T2"." UNIT_ID" "c167","t2"." LICENSE_ID" "c168","t2"." ORGANIZATION_NAME" "c170", SUMA ( "t1"." QTR_REPORTS" )
"a0", SUMA ( "t1"." L8_TOTAL_NET_RECEIPTS" )
"A1"
DE
(
(
(
(
ESCOGER
"DIM_BINGO_QTR_ID","DIM_BINGO_ORG_ID","DIM_BINGO_QR_CODE_ID",
CAST("QTR_REPORTS" como NÚMERO(19, 0))
"QTR_REPORTS","L8_TOTAL_NET_RECEIPTS"
DE
(
(
escoger
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
desde jspr_fact_bingo_qtr_reports_vw
)
)
"T1"
)
"T1"
UNIÓN INTERNA
(
escoger
DIM_BINGO_QTR_ID,
FILING_PERIOD,
CAL_YEAR,
CAL_QTR,
DUE_DATE,
QTR_BEGIN_DATE,
QTR_END_DATE
desde jspr_dim_bingo_qtrs_vw
) "t0" el
(
"T1"." DIM_BINGO_QTR_ID" = "t0"." DIM_BINGO_QTR_ID"
)
)
UNIÓN INTERNA
(
ESCOGER
"DIM_BINGO_ORG_ID",
CAST("UNIT_ID" como NÚMERO(19, 0))
"UNIT_ID",
CAST("LICENSE_ID" como NÚMERO(19, 0))
"LICENSE_ID","ORGANIZATION_TYPE","ORGANIZATION_NAME"
DE
(
(
seleccione DIM_BINGO_ORG_ID, LIC_UNIT_ID, ORG_UNIT_ID, ORGANIZATION_ID, CAST(UNIT_ID AS NUMBER(15,0)) UNIT_ID,
REPARTO (LICENSE_ID NÚMERO(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
desde jspr_dim_bingo_orgs_vw
)
)
"T2"
)
"T2" en
(
"T1"." DIM_BINGO_ORG_ID" = "t2"." DIM_BINGO_ORG_ID"
)
)
UNIÓN INTERNA
(
escoger
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
desde jspr_dim_bingo_qr_codes_vw
) "t3" el
(
"T1"." DIM_BINGO_QR_CODE_ID" = "t3"." DIM_BINGO_QR_CODE_ID"
)
)
DÓNDE
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T3"." FILING_STATUS" = 'Archivado'
)
)
Y
(
(
(SELECCIONE INSTR(Op2, Op1, Op3) FROM (SELECT UPPER('O') AS Op1, UPPER("T2"." ORGANIZATION_NAME") COMO Op2, 1 COMO Op3 DE DUAL) AuxTable)
= 1)
Y
(
("T2"." ORGANIZATION_TYPE" IN ('Conductor','Conductor no regular','Unidad'))
)
)
)
Y
(
(
(
(
(
(
(
(
(
"T2"." LICENSE_ID" = 117602
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia de Nuestra Señora de Guadalupe'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 117898
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia de Nuestra Señora de Guadalupe'
)
)
)
O
(
(
(
(
"T2"." LICENSE_ID" = 118191
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora de los Ángeles'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 1871
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora del Rosario'
)
)
)
)
O
(
(
(
(
(
"T2"." LICENSE_ID" = 1492
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora de Guadalupe'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 237099
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Colegio Católico Nuestra Señora del Perpetuo Socorro'
)
)
)
O
(
(
(
"T2"." LICENSE_ID" = 238152
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Outreach United'
)
)
)
)
O
(
(
(
(
(
"T2"." LICENSE_ID" = 244332
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Operación Phantom Support Inc'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 3469
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora del Refugio'
)
)
)
O
(
(
(
(
"T2"." LICENSE_ID" = 117121
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Parroquia y Santuario de Nuestra Señora de Guadalupe'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 261044
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia de Nuestra Señora de Guadalupe'
)
)
)
)
)
O
(
(
(
(
(
(
"T2"." LICENSE_ID" = 212626
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Academia Nuestra Señora de Gracia'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 117556
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora Reina del Cielo'
)
)
)
O
(
(
(
(
"T2"." LICENSE_ID" = 117677
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora Reina de la Paz'
)
)
O
(
(
(
"T2"." LICENSE_ID" ES NULL
)
Y
(
"T2"." UNIT_ID" = 562
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Oasis Bingo Unit Trust'
)
)
)
)
O
(
(
(
(
(
"T2"." LICENSE_ID" = 1212
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Orden De La Alhambra Alva Caravan #91'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 2769
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Club de Leones de Odessa Westside'
)
)
)
O
(
(
(
(
"T2"." LICENSE_ID" = 117236
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica de Nuestra Señora de la Consolación'
)
)
O
(
(
(
"T2"." LICENSE_ID" = 118046
)
Y
(
"T2"." UNIT_ID" ES NULL
)
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia de Nuestra Señora del Buen Consejo'
)
)
)
)
)
)
Y
(
(
(
(
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 117602
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia de Nuestra Señora de Guadalupe'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 117898
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Nuestra Señora de Guadalupe Iglesia'
)
)
)
)
O
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 118191
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora de los Ángeles'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 1871
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora del Rosario'
)
)
)
)
)
O
(
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 1492
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora de Guadalupe'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 237099
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Colegio Católico Nuestra Señora del Perpetuo Socorro'
)
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 238152
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Outreach United'
)
)
)
)
)
O
(
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 244332
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Operación Phantom Support Inc'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 3469
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora del Refugio'
)
)
)
)
O
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 117121
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Parroquia y Santuario de Nuestra Señora de Guadalupe'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 261044
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia de Nuestra Señora de Guadalupe'
)
)
)
)
)
)
O
(
(
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 212626
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Academia Nuestra Señora de Gracia'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 117556
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora Reina del Cielo'
)
)
)
)
O
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 117677
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica Nuestra Señora Reina de la Paz'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" ES NULL
)
)
Y
(
(
"T2"." UNIT_ID" = 562
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Oasis Bingo Unit Trust'
)
)
)
)
)
O
(
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 1212
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Orden De La Alhambra Alva Caravan #91'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 2769
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Club de Leones de Odessa Westside'
)
)
)
)
O
(
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 117236
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia Católica de Nuestra Señora de la Consolación'
)
)
)
O
(
(
(
"t0"." FILING_PERIOD" = '20224'
)
Y
(
"T2"." LICENSE_ID" = 118046
)
)
Y
(
(
"T2"." UNIT_ID" ES NULL
)
Y
(
"T2"." ORGANIZATION_NAME" = 'Iglesia de Nuestra Señora del Buen Consejo'
)
)
)
)
)
)
)
)
)
AGRUPAR POR "t2"." UNIT_ID","t2"." LICENSE_ID","t2"." ORGANIZATION_NAME"
)
"MainTable"
DÓNDE
(
NO(
(
"a0" ES NULL
)
)
O
NO(
(
"A1" ES NULL
)
)
)
