Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- b.name bank,
- ib.YEAR,
- ib.MONTH,
- ip.category,
- customer.customer_number,
- customer.name,
- customer.has_bad_address,
- address.line1,
- address.line2,
- address.city,
- state.name,
- address.zip,
- po_box.line1,
- po_box.line2,
- po_box.city,
- po_state.name,
- po_box.zip,
- customer.date_of_birth,
- northway_account.cffna,
- northway_account.cfinsc,
- customer.deceased,
- customer.social_security_number,
- customer.has_internet_banking,
- customer.safe_deposit_box,
- account.has_bill_pay,
- account.has_e_statement,
- branch.NUMBER,
- northway_product.code,
- macatawa_product.code,
- account.account_number,
- account.available_line,
- view_macatawa_atm_card.NUMBER,
- view_macatawa_debit_card.NUMBER,
- uc.code use_class,
- account.open_date,
- account.balance,
- account.affinion,
- northway_account.ytdsc,
- northway_account.ytdodf,
- northway_account.ytdnsf,
- northway_account.rtckcy,
- northway_account.rtckwy,
- northway_account.odwvey,
- northway_account.ytdscw,
- northway_account.feeytd,
- customer.do_not_mail,
- northway_account.aledq1,
- northway_account.aledq2,
- northway_account.aledq3,
- northway_account.aledq4,
- northway_account.acolq1,
- northway_account.acolq2,
- northway_account.acolq3,
- northway_account.acolq4,
- o.officer_number,
- northway_account.avg_bal_1,
- northway_account.avg_bal_2,
- northway_account.avg_bal_3,
- account.maturity_date,
- account.interest_rate,
- northway_account.asslc,
- northway_account.paidlc,
- northway_account.lnuchg,
- northway_account.ytdlc,
- northway_account.extfee,
- northway_account.penamt,
- northway_account.cdytdwaive,
- northway_account.cdterm,
- northway_account.cdtcod,
- account.date_of_last_statement,
- northway_account.statement_cycle,
- northway_account.cfna1,
- northway_account.cfna2,
- northway_account.cfna3,
- northway_account.cfna4,
- northway_account.cfcity,
- northway_account.cfstate,
- northway_account.cfzip,
- northway_account.actype,
- northway_account.sccode,
- macatawa_account.account_type_code,
- macatawa_account.account_type_code_description,
- macatawa_account.advance_code,
- macatawa_account.amount_last_advance,
- macatawa_account.amount_last_payment,
- macatawa_account.available_credit,
- macatawa_account.balance_last_statement,
- macatawa_account.billing_day,
- macatawa_account.birthday_3,
- macatawa_account.birthday_name_2,
- macatawa_account.ceiling_rate,
- macatawa_account.class_code,
- macatawa_account.classified_doubtful,
- macatawa_account.classified_loss,
- macatawa_account.classified_special,
- macatawa_account.classified_substandard,
- macatawa_account.closed_account_flag,
- macatawa_account.closing_balance,
- macatawa_account.compounding_code,
- macatawa_account.cost_center_full,
- macatawa_account.cytd_aggregate_balance,
- macatawa_account.cytd_amount_of_advances,
- macatawa_account.cytd_amount_of_payments,
- macatawa_account.cytd_average_balance,
- macatawa_account.cytd_average_principal_balance,
- macatawa_account.cytd_interest_paid,
- macatawa_account.cytd_number_items_nsf,
- macatawa_account.cytd_number_of_advanes,
- macatawa_account.cytd_number_of_payments,
- macatawa_account.cytd_number_times_od,
- macatawa_account.cytd_other_charges,
- macatawa_account.cytd_other_charges_waived,
- macatawa_account.cytd_reporting_points,
- macatawa_account.cytd_service_charge,
- macatawa_account.cytd_service_charge_waived,
- macatawa_account.date_closed,
- macatawa_account.date_last_activity,
- macatawa_account.date_last_advance,
- macatawa_account.date_last_payment,
- macatawa_account.date_paid_off,
- macatawa_account.ddl_code,
- macatawa_account.deposit_rate_index,
- macatawa_account.employee_officer_director_full_desc,
- macatawa_account.floor_rate,
- macatawa_account.handling_code,
- macatawa_account.how_paid_code,
- macatawa_account.interest_frequency,
- macatawa_account.ira_plan,
- macatawa_account.load_rate_code,
- macatawa_account.loan_rate_code,
- macatawa_account.loan_rating_code,
- macatawa_account.loan_rating_code_1_full_desc,
- macatawa_account.loan_rating_code_2_full_desc,
- macatawa_account.loan_rating_code_3_full_desc,
- macatawa_account.loan_to_value_ratio,
- macatawa_account.maximum_credit,
- macatawa_account.miscellaneous_code_full_desc,
- macatawa_account.months_to_maturity,
- macatawa_account.msa_code,
- macatawa_account.mtd_agg_available_balance,
- macatawa_account.naics_code,
- macatawa_account.name_2,
- macatawa_account.name_3,
- macatawa_account.name_line,
- macatawa_account.name_line_2,
- macatawa_account.name_line_3,
- macatawa_account.name_line_1,
- macatawa_account.net_payoff,
- macatawa_account.opened_by_responsibility_code_full,
- macatawa_account.original_issue_date,
- macatawa_account.original_maturity_date,
- macatawa_account.original_note_amount,
- macatawa_account.original_note_date,
- macatawa_account.original_prepaid_fees,
- macatawa_account.participation_placed_code,
- macatawa_account.participation_priority_code,
- macatawa_account.pay_to_account,
- macatawa_account.payment_code,
- macatawa_account.payoff_principal_balance,
- macatawa_account.percent_participated_code,
- macatawa_account.pmtd_number_deposit_type_1,
- macatawa_account.pmtd_number_deposit_type_2,
- macatawa_account.pmtd_number_deposit_type_3,
- macatawa_account.pmtd_number_type_1,
- macatawa_account.pmtd_number_type_2,
- macatawa_account.pmtd_number_type_6,
- macatawa_account.pmtd_number_type_8,
- macatawa_account.pmtd_number_type_9,
- macatawa_account.principal,
- macatawa_account.purpose_code,
- macatawa_account.purpose_code_full_desc,
- macatawa_account.pytd_number_of_items_nsf,
- macatawa_account.pytd_number_of_times_od,
- macatawa_account.rate_adjuster,
- macatawa_account.rate_over_split,
- macatawa_account.rate_under_split,
- macatawa_account.renewal_code,
- macatawa_account.renewal_date,
- macatawa_account.responsibility_code_full,
- macatawa_account.secured_unsecured_code,
- macatawa_account.short_first_name_1,
- macatawa_account.short_first_name_2,
- macatawa_account.short_first_name_3,
- macatawa_account.short_last_name_1,
- macatawa_account.short_last_name_2,
- macatawa_account.short_last_name_3,
- macatawa_account.statement_cycle,
- macatawa_account.statement_rate,
- macatawa_account.status_code,
- macatawa_account.tax_id_number_name_2,
- macatawa_account.tax_id_number_name_3,
- macatawa_account.teller_alert_1,
- macatawa_account.teller_alert_2,
- macatawa_account.teller_alert_3,
- macatawa_account.term,
- macatawa_account.term_code,
- macatawa_account.times_past_due_01_29,
- macatawa_account.times_past_due_01_to_29_days,
- macatawa_account.times_past_due_30_59,
- macatawa_account.times_past_due_30_to_59_days,
- macatawa_account.times_past_due_60_89,
- macatawa_account.times_past_due_60_to_89_days,
- macatawa_account.times_past_due_over_90,
- macatawa_account.times_past_due_over_90_days,
- macatawa_account.tin_code_name_1,
- macatawa_account.tin_code_name,
- macatawa_account.tin_code_name_2,
- macatawa_account.tin_code_name_3,
- macatawa_account.total_amount_past_due,
- macatawa_account.waiver_od_charge,
- macatawa_account.waiver_od_charge_description,
- macatawa_account.waiver_service_charge_code,
- macatawa_account.waiver_transfer_advance_fee,
- macatawa_account.short_first_name,
- macatawa_account.short_last_name
- FROM account
- JOIN customer ON account.customer_id = customer.id
- JOIN officer o ON account.officer_id = o.id
- JOIN account_address aa ON aa.account_id = account.id
- LEFT JOIN account_po_box apb ON apb.account_id = account.id
- JOIN address ON aa.address_id = address.id
- LEFT JOIN original_address oa ON oa.account_id = account.id
- LEFT JOIN address po_box ON apb.address_id = po_box.id
- JOIN state ON state.id = address.state_id
- LEFT JOIN state po_state ON po_state.id = po_box.state_id
- LEFT JOIN branch ON account.branch_id = branch.id
- JOIN account_import ai ON account.account_import_id = ai.id
- JOIN generic_import gi ON gi.id = ai.generic_import_id
- JOIN import_bundle ib ON gi.import_bundle_id = ib.id
- JOIN import_profile ip ON gi.import_profile_id = ip.id
- JOIN bank b ON b.id = ib.bank_id
- LEFT JOIN cd_type ON account.cd_type_id = cd_type.id
- LEFT JOIN account_macatawa_product amp ON amp.account_id = account.id
- LEFT JOIN account_northway_product anp ON anp.account_id = account.id
- LEFT JOIN macatawa_product ON macatawa_product.id = amp.macatawa_product_id
- LEFT JOIN northway_product ON northway_product.id = anp.northway_product_id
- LEFT JOIN product_type pt ON pt.id = macatawa_product.product_type_id
- LEFT JOIN harte_hanks_service_category hhsc ON hhsc.id = macatawa_product.harte_hanks_service_category_id
- LEFT JOIN core_file_type cft ON cft.id = macatawa_product.core_file_type_id
- LEFT JOIN use_class uc ON account.use_class_id = uc.id
- LEFT JOIN account_type at ON account.account_type_id = at.id
- LEFT JOIN northway_account ON northway_account.account_id = account.id
- LEFT JOIN macatawa_account ON macatawa_account.account_id = account.id
- LEFT JOIN view_macatawa_debit_card ON view_macatawa_debit_card.account_id = account.id
- LEFT JOIN view_macatawa_atm_card ON view_macatawa_atm_card.account_id = account.id
- WHERE 1
- AND gi.active = 1
- AND ib.active = 1
- AND ib.id = 95
- LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement