Before the error, are there other logs that show data fetching from JDBC succeeds?
If Account has an association to another Account which you are left join fetching, that might be an indicator about what is going on
Or maybe the first row contains account 1 and the second row refers to this account 1 through an association
Summary
The exact query (or queries):
SELECT DISTINCT a1_0.id,
acp1_0.account,
acp1_0.cauliflower_pool,
acp1_0.type,
a1_0.account_class,
a1_0.account_type_id,
a1_0.alternative_name,
a1_0.balances_preferred_source_id,
a1_0.balances_preferred_source_type,
a1_0.balancing_type,
bb1_0.id,
b1_0.id,
b1_0.bic,
b1_0.business_id,
b1_0.city,
b1_0.country,
b1_0.creation_time,
b1_0.last_update_time,
b1_0.NAME,
b1_0.paybird_config,
b1_0.postal_code,
b1_0.street,
bb1_0.bic,
bb1_0.business_id,
bb1_0.city,
bb1_0.country,
bb1_0.creation_time,
hc1_0.barron_branch_id,
hc1_1.id,
hc1_1.creation_time,
hc1_1.description,
hc1_1.last_update_time,
hc1_1.NAME,
bb1_0.last_update_time,
bb1_0.NAME,
bb1_0.paybird_config,
bb1_0.postal_code,
bb1_0.street,
bb1_0.time_zone,
a1_0.business_id,
a1_0.closing_date,
a1_0.creation_time,
a1_0.currency_id,
c1_0.id,
c1_0.creation_time,
c1_0.last_message,
c1_0.last_update_time,
c1_0.NAME,
c1_0.PRECISION,
c1_0.status,
c1_0.system_managed,
a1_0.general_ledger_number,
ima1_0.id,
ima1_0.account_class,
ima1_0.account_type_id,
ima1_0.alternative_name,
ima1_0.balances_preferred_source_id,
ima1_0.balances_preferred_source_type,
ima1_0.balancing_type,
ima1_0.barron_branch_id,
ima1_0.business_id,
ima1_0.closing_date,
ima1_0.creation_time,
ima1_0.currency_id,
ima1_0.general_ledger_number,
ima1_0.ihb_mirroring_account_id,
ima1_0.last_import_timestamp,
ima1_0.last_update_time,
ima1_0.legal_holder_id,
ima1_0.min_funding_amount,
ima1_0.min_sweeping_amount,
ima1_0.NAME,
ima1_0.opening_date,
ima1_0.operational_holder_id,
ima1_0.paybird_config,
ima1_0.period_lock_end_date,
ima1_0.target_balance,
ima1_0.transactions_preferred_source_id,
a1_0.last_import_timestamp,
a1_0.last_update_time,
lh1_0.id,
lh1_0.alternative_name,
lh1_0.business_id,
lh1_0.closing_date,
lh1_0.code,
lh1_0.creation_time,
lh1_0.currency_id,
lh1_0.entity_type_id,
lh1_0.last_update_time,
lh1_0.NAME,
lh1_0.opening_date,
lh1_0.paybird_config,
a1_0.min_funding_amount,
a1_0.min_sweeping_amount,
a1_0.NAME,
a1_0.opening_date,
a1_0.operational_holder_id,
oh1_0.id,
oh1_0.alternative_name,
oh1_0.business_id,
oh1_0.closing_date,
oh1_0.code,
oh1_0.creation_time,
oh1_0.currency_id,
oh1_0.entity_type_id,
oh1_0.last_update_time,
oh1_0.NAME,
oh1_0.opening_date,
oh1_0.paybird_config,
a1_0.paybird_config,
a1_0.period_lock_end_date,
a1_0.target_balance,
a1_0.transactions_preferred_source_id
FROM account a1_0
LEFT JOIN barron_branch bb1_0
ON bb1_0.id = a1_0.barron_branch_id
LEFT JOIN barron b1_0
ON b1_0.id = bb1_0.bank_id
LEFT JOIN barron_branch_holiday_calendar hc1_0
ON bb1_0.id = hc1_0.barron_branch_id
LEFT JOIN holiday_calendar hc1_1
ON hc1_1.id = hc1_0.holiday_calendars_id
LEFT JOIN account_cauliflower_pool acp1_0
ON a1_0.id = acp1_0.account
LEFT JOIN currency c1_0
ON c1_0.id = a1_0.currency_id
LEFT JOIN account ima1_0
ON ima1_0.id = a1_0.ihb_mirroring_account_id
LEFT JOIN entity oh1_0
ON oh1_0.id = a1_0.operational_holder_id
LEFT JOIN entity lh1_0
ON lh1_0.id = a1_0.legal_holder_id
SELECT cp1_0.id,
cp1_0.creation_time,
c1_0.id,
c1_0.creation_time,
c1_0.last_message,
c1_0.last_update_time,
c1_0.NAME,
c1_0.PRECISION,
c1_0.status,
c1_0.system_managed,
cp1_0.last_update_time,
cp1_0.NAME,
cp1_0.status,
cp1_0.type
FROM cauliflower_pool cp1_0
LEFT JOIN currency c1_0
ON c1_0.id = cp1_0.currency_id
WHERE cp1_0.id = ?
SELECT acp1_0.account,
a1_0.id,
a1_0.account_class,
at1_0.id,
at1_0.creation_time,
at1_0.description,
at1_0.item,
at1_0.last_update_time,
at1_0.level_id,
l1_0.id,
l1_0.creation_time,
l1_0.last_update_time,
l1_0.NAME,
l1_0.order_nr,
at1_0.order_nr,
at1_0.parent_id,
a1_0.alternative_name,
bps1_0.id,
bps1_0.configuration,
bps1_0.creation_time,
bps1_0.disabled,
bps1_0.last_update_time,
bps1_0.NAME,
bps1_0.system_managed,
bps1_0.type,
f1_0.instance_id,
f1_0.id,
f1_0.creation_time,
f1_0.feature_code,
f1_0.last_refresh_time,
f1_0.last_update_time,
f1_0.nature,
f1_0.status,
a1_0.balances_preferred_source_type,
a1_0.balancing_type,
bb1_0.id,
b1_0.id,
b1_0.bic,
b1_0.business_id,
b1_0.city,
b1_0.country,
b1_0.creation_time,
b1_0.last_update_time,
b1_0.NAME,
b1_0.paybird_config,
b1_0.postal_code,
b1_0.street,
bb1_0.bic,
bb1_0.business_id,
bb1_0.city,
bb1_0.country,
bb1_0.creation_time,
bb1_0.last_update_time,
bb1_0.NAME,
bb1_0.paybird_config,
bb1_0.postal_code,
bb1_0.street,
bb1_0.time_zone,
a1_0.business_id,
a1_0.closing_date,
a1_0.creation_time,
a1_0.currency_id,
c1_0.id,
c1_0.creation_time,
c1_0.last_message,
c1_0.last_update_time,
c1_0.NAME,
c1_0.PRECISION,
c1_0.status,
c1_0.system_managed,
a1_0.general_ledger_number,
ima1_0.id,
ima1_0.account_class,
at2_0.id,
at2_0.creation_time,
at2_0.description,
at2_0.item,
at2_0.last_update_time,
at2_0.level_id,
l2_0.id,
l2_0.creation_time,
l2_0.last_update_time,
l2_0.NAME,
l2_0.order_nr,
at2_0.order_nr,
at2_0.parent_id,
ima1_0.alternative_name,
bps2_0.id,
bps2_0.configuration,
bps2_0.creation_time,
bps2_0.disabled,
bps2_0.last_update_time,
bps2_0.NAME,
bps2_0.system_managed,
bps2_0.type,
ima1_0.balances_preferred_source_type,
ima1_0.balancing_type,
bb2_0.id,
b2_0.id,
b2_0.bic,
b2_0.business_id,
b2_0.city,
b2_0.country,
b2_0.creation_time,
b2_0.last_update_time,
b2_0.NAME,
b2_0.paybird_config,
b2_0.postal_code,
b2_0.street,
bb2_0.bic,
bb2_0.business_id,
bb2_0.city,
bb2_0.country,
bb2_0.creation_time,
bb2_0.last_update_time,
bb2_0.NAME,
bb2_0.paybird_config,
bb2_0.postal_code,
bb2_0.street,
bb2_0.time_zone,
ima1_0.business_id,
ima1_0.closing_date,
ima1_0.creation_time,
ima1_0.currency_id,
c2_0.id,
c2_0.creation_time,
c2_0.last_message,
c2_0.last_update_time,
c2_0.NAME,
c2_0.PRECISION,
c2_0.status,
c2_0.system_managed,
ima1_0.general_ledger_number,
ima1_0.ihb_mirroring_account_id,
ima1_0.last_import_timestamp,
ima1_0.last_update_time,
lh1_0.id,
lh1_0.alternative_name,
lh1_0.business_id,
lh1_0.closing_date,
lh1_0.code,
lh1_0.creation_time,
c3_0.id,
c3_0.creation_time,
c3_0.last_message,
c3_0.last_update_time,
c3_0.NAME,
c3_0.PRECISION,
c3_0.status,
c3_0.system_managed,
et1_0.id,
et1_0.creation_time,
et1_0.description,
et1_0.item,
et1_0.last_update_time,
et1_0.level_id,
l3_0.id,
l3_0.creation_time,
l3_0.last_update_time,
l3_0.NAME,
l3_0.order_nr,
et1_0.order_nr,
et1_0.parent_id,
lh1_0.last_update_time,
lh1_0.NAME,
lh1_0.opening_date,
lh1_0.paybird_config,
ima1_0.min_funding_amount,
ima1_0.min_sweeping_amount,
ima1_0.NAME,
ima1_0.opening_date,
ima1_0.operational_holder_id,
oh1_0.id,
oh1_0.alternative_name,
oh1_0.business_id,
oh1_0.closing_date,
oh1_0.code,
oh1_0.creation_time,
c4_0.id,
c4_0.creation_time,
c4_0.last_message,
c4_0.last_update_time,
c4_0.NAME,
c4_0.PRECISION,
c4_0.status,
c4_0.system_managed,
et2_0.id,
et2_0.creation_time,
et2_0.description,
et2_0.item,
et2_0.last_update_time,
et2_0.level_id,
l4_0.id,
l4_0.creation_time,
l4_0.last_update_time,
l4_0.NAME,
l4_0.order_nr,
et2_0.order_nr,
et2_0.parent_id,
oh1_0.last_update_time,
oh1_0.NAME,
oh1_0.opening_date,
oh1_0.paybird_config,
ima1_0.paybird_config,
ima1_0.period_lock_end_date,
ima1_0.target_balance,
tps1_0.id,
tps1_0.configuration,
tps1_0.creation_time,
tps1_0.disabled,
tps1_0.last_update_time,
tps1_0.NAME,
tps1_0.system_managed,
tps1_0.type,
a1_0.last_import_timestamp,
a1_0.last_update_time,
lh2_0.id,
lh2_0.alternative_name,
lh2_0.business_id,
lh2_0.closing_date,
lh2_0.code,
lh2_0.creation_time,
c5_0.id,
c5_0.creation_time,
c5_0.last_message,
c5_0.last_update_time,
c5_0.NAME,
c5_0.PRECISION,
c5_0.status,
c5_0.system_managed,
et3_0.id,
et3_0.creation_time,
et3_0.description,
et3_0.item,
et3_0.last_update_time,
et3_0.level_id,
l5_0.id,
l5_0.creation_time,
l5_0.last_update_time,
l5_0.NAME,
l5_0.order_nr,
et3_0.order_nr,
et3_0.parent_id,
lh2_0.last_update_time,
lh2_0.NAME,
lh2_0.opening_date,
lh2_0.paybird_config,
a1_0.min_funding_amount,
a1_0.min_sweeping_amount,
a1_0.NAME,
a1_0.opening_date,
a1_0.operational_holder_id,
oh2_0.id,
oh2_0.alternative_name,
oh2_0.business_id,
oh2_0.closing_date,
oh2_0.code,
oh2_0.creation_time,
c6_0.id,
c6_0.creation_time,
c6_0.last_message,
c6_0.last_update_time,
c6_0.NAME,
c6_0.PRECISION,
c6_0.status,
c6_0.system_managed,
et4_0.id,
et4_0.creation_time,
et4_0.description,
et4_0.item,
et4_0.last_update_time,
et4_0.level_id,
l6_0.id,
l6_0.creation_time,
l6_0.last_update_time,
l6_0.NAME,
l6_0.order_nr,
et4_0.order_nr,
et4_0.parent_id,
oh2_0.last_update_time,
oh2_0.NAME,
oh2_0.opening_date,
oh2_0.paybird_config,
a1_0.paybird_config,
a1_0.period_lock_end_date,
a1_0.target_balance,
tps2_0.id,
tps2_0.configuration,
tps2_0.creation_time,
tps2_0.disabled,
tps2_0.last_update_time,
tps2_0.NAME,
tps2_0.system_managed,
tps2_0.type,
acp1_0.cauliflower_pool,
cp1_0.id,
cp1_0.creation_time,
c7_0.id,
c7_0.creation_time,
c7_0.last_message,
c7_0.last_update_time,
c7_0.NAME,
c7_0.PRECISION,
c7_0.status,
c7_0.system_managed,
cp1_0.last_update_time,
cp1_0.NAME,
cp1_0.status,
cp1_0.type,
acp1_0.type
FROM account_cauliflower_pool acp1_0
JOIN account a1_0
ON a1_0.id = acp1_0.account
LEFT JOIN account_type at1_0
ON at1_0.id = a1_0.account_type_id
LEFT JOIN account_type_level l1_0
ON l1_0.id = at1_0.level_id
LEFT JOIN connector_instance bps1_0
ON bps1_0.id = a1_0.balances_preferred_source_id
AND bps1_0.deleted = false
LEFT JOIN connector_instance_feature f1_0
ON bps1_0.id = f1_0.instance_id
AND f1_0.deleted = false
LEFT JOIN barron_branch bb1_0
ON bb1_0.id = a1_0.barron_branch_id
LEFT JOIN barron b1_0
ON b1_0.id = bb1_0.bank_id
JOIN currency c1_0
ON c1_0.id = a1_0.currency_id
LEFT JOIN account ima1_0
ON ima1_0.id = a1_0.ihb_mirroring_account_id
LEFT JOIN account_type at2_0
ON at2_0.id = ima1_0.account_type_id
LEFT JOIN account_type_level l2_0
ON l2_0.id = at2_0.level_id
LEFT JOIN connector_instance bps2_0
ON bps2_0.id = ima1_0.balances_preferred_source_id
AND bps2_0.deleted = false
LEFT JOIN barron_branch bb2_0
ON bb2_0.id = ima1_0.barron_branch_id
LEFT JOIN barron b2_0
ON b2_0.id = bb2_0.bank_id
LEFT JOIN currency c2_0
ON c2_0.id = ima1_0.currency_id
LEFT JOIN entity lh1_0
ON lh1_0.id = ima1_0.legal_holder_id
LEFT JOIN currency c3_0
ON c3_0.id = lh1_0.currency_id
LEFT JOIN entity_type et1_0
ON et1_0.id = lh1_0.entity_type_id
LEFT JOIN entity_type_level l3_0
ON l3_0.id = et1_0.level_id
LEFT JOIN entity oh1_0
ON oh1_0.id = ima1_0.operational_holder_id
LEFT JOIN currency c4_0
ON c4_0.id = oh1_0.currency_id
LEFT JOIN entity_type et2_0
ON et2_0.id = oh1_0.entity_type_id
LEFT JOIN entity_type_level l4_0
ON l4_0.id = et2_0.level_id
LEFT JOIN connector_instance tps1_0
ON tps1_0.id = ima1_0.transactions_preferred_source_id
AND tps1_0.deleted = false
LEFT JOIN entity lh2_0
ON lh2_0.id = a1_0.legal_holder_id
LEFT JOIN currency c5_0
ON c5_0.id = lh2_0.currency_id
LEFT JOIN entity_type et3_0
ON et3_0.id = lh2_0.entity_type_id
LEFT JOIN entity_type_level l5_0
ON l5_0.id = et3_0.level_id
JOIN entity oh2_0
ON oh2_0.id = a1_0.operational_holder_id
LEFT JOIN currency c6_0
ON c6_0.id = oh2_0.currency_id
LEFT JOIN entity_type et4_0
ON et4_0.id = oh2_0.entity_type_id
LEFT JOIN entity_type_level l6_0
ON l6_0.id = et4_0.level_id
LEFT JOIN connector_instance tps2_0
ON tps2_0.id = a1_0.transactions_preferred_source_id
AND tps2_0.deleted = false
JOIN cauliflower_pool cp1_0
ON cp1_0.id = acp1_0.cauliflower_pool
LEFT JOIN currency c7_0
ON c7_0.id = cp1_0.currency_id
WHERE acp1_0.account = ?
SELECT acp1_0.account,
a1_0.id,
a1_0.account_class,
at1_0.id,
at1_0.creation_time,
at1_0.description,
at1_0.item,
at1_0.last_update_time,
at1_0.level_id,
l1_0.id,
l1_0.creation_time,
l1_0.last_update_time,
l1_0.NAME,
l1_0.order_nr,
at1_0.order_nr,
at1_0.parent_id,
a1_0.alternative_name,
bps1_0.id,
bps1_0.configuration,
bps1_0.creation_time,
bps1_0.disabled,
bps1_0.last_update_time,
bps1_0.NAME,
bps1_0.system_managed,
bps1_0.type,
f1_0.instance_id,
f1_0.id,
f1_0.creation_time,
f1_0.feature_code,
f1_0.last_refresh_time,
f1_0.last_update_time,
f1_0.nature,
f1_0.status,
a1_0.balances_preferred_source_type,
a1_0.balancing_type,
bb1_0.id,
b1_0.id,
b1_0.bic,
b1_0.business_id,
b1_0.city,
b1_0.country,
b1_0.creation_time,
b1_0.last_update_time,
b1_0.NAME,
b1_0.paybird_config,
b1_0.postal_code,
b1_0.street,
bb1_0.bic,
bb1_0.business_id,
bb1_0.city,
bb1_0.country,
bb1_0.creation_time,
bb1_0.last_update_time,
bb1_0.NAME,
bb1_0.paybird_config,
bb1_0.postal_code,
bb1_0.street,
bb1_0.time_zone,
a1_0.business_id,
a1_0.closing_date,
a1_0.creation_time,
a1_0.currency_id,
c1_0.id,
c1_0.creation_time,
c1_0.last_message,
c1_0.last_update_time,
c1_0.NAME,
c1_0.PRECISION,
c1_0.status,
c1_0.system_managed,
a1_0.general_ledger_number,
ima1_0.id,
ima1_0.account_class,
at2_0.id,
at2_0.creation_time,
at2_0.description,
at2_0.item,
at2_0.last_update_time,
at2_0.level_id,
l2_0.id,
l2_0.creation_time,
l2_0.last_update_time,
l2_0.NAME,
l2_0.order_nr,
at2_0.order_nr,
at2_0.parent_id,
ima1_0.alternative_name,
bps2_0.id,
bps2_0.configuration,
bps2_0.creation_time,
bps2_0.disabled,
bps2_0.last_update_time,
bps2_0.NAME,
bps2_0.system_managed,
bps2_0.type,
ima1_0.balances_preferred_source_type,
ima1_0.balancing_type,
bb2_0.id,
b2_0.id,
b2_0.bic,
b2_0.business_id,
b2_0.city,
b2_0.country,
b2_0.creation_time,
b2_0.last_update_time,
b2_0.NAME,
b2_0.paybird_config,
b2_0.postal_code,
b2_0.street,
bb2_0.bic,
bb2_0.business_id,
bb2_0.city,
bb2_0.country,
bb2_0.creation_time,
bb2_0.last_update_time,
bb2_0.NAME,
bb2_0.paybird_config,
bb2_0.postal_code,
bb2_0.street,
bb2_0.time_zone,
ima1_0.business_id,
ima1_0.closing_date,
ima1_0.creation_time,
ima1_0.currency_id,
c2_0.id,
c2_0.creation_time,
c2_0.last_message,
c2_0.last_update_time,
c2_0.NAME,
c2_0.PRECISION,
c2_0.status,
c2_0.system_managed,
ima1_0.general_ledger_number,
ima1_0.ihb_mirroring_account_id,
ima1_0.last_import_timestamp,
ima1_0.last_update_time,
lh1_0.id,
lh1_0.alternative_name,
lh1_0.business_id,
lh1_0.closing_date,
lh1_0.code,
lh1_0.creation_time,
c3_0.id,
c3_0.creation_time,
c3_0.last_message,
c3_0.last_update_time,
c3_0.NAME,
c3_0.PRECISION,
c3_0.status,
c3_0.system_managed,
et1_0.id,
et1_0.creation_time,
et1_0.description,
et1_0.item,
et1_0.last_update_time,
et1_0.level_id,
l3_0.id,
l3_0.creation_time,
l3_0.last_update_time,
l3_0.NAME,
l3_0.order_nr,
et1_0.order_nr,
et1_0.parent_id,
lh1_0.last_update_time,
lh1_0.NAME,
lh1_0.opening_date,
lh1_0.paybird_config,
ima1_0.min_funding_amount,
ima1_0.min_sweeping_amount,
ima1_0.NAME,
ima1_0.opening_date,
ima1_0.operational_holder_id,
oh1_0.id,
oh1_0.alternative_name,
oh1_0.business_id,
oh1_0.closing_date,
oh1_0.code,
oh1_0.creation_time,
c4_0.id,
c4_0.creation_time,
c4_0.last_message,
c4_0.last_update_time,
c4_0.NAME,
c4_0.PRECISION,
c4_0.status,
c4_0.system_managed,
et2_0.id,
et2_0.creation_time,
et2_0.description,
et2_0.item,
et2_0.last_update_time,
et2_0.level_id,
l4_0.id,
l4_0.creation_time,
l4_0.last_update_time,
l4_0.NAME,
l4_0.order_nr,
et2_0.order_nr,
et2_0.parent_id,
oh1_0.last_update_time,
oh1_0.NAME,
oh1_0.opening_date,
oh1_0.paybird_config,
ima1_0.paybird_config,
ima1_0.period_lock_end_date,
ima1_0.target_balance,
tps1_0.id,
tps1_0.configuration,
tps1_0.creation_time,
tps1_0.disabled,
tps1_0.last_update_time,
tps1_0.NAME,
tps1_0.system_managed,
tps1_0.type,
a1_0.last_import_timestamp,
a1_0.last_update_time,
lh2_0.id,
lh2_0.alternative_name,
lh2_0.business_id,
lh2_0.closing_date,
lh2_0.code,
lh2_0.creation_time,
c5_0.id,
c5_0.creation_time,
c5_0.last_message,
c5_0.last_update_time,
c5_0.NAME,
c5_0.PRECISION,
c5_0.status,
c5_0.system_managed,
et3_0.id,
et3_0.creation_time,
et3_0.description,
et3_0.item,
et3_0.last_update_time,
et3_0.level_id,
l5_0.id,
l5_0.creation_time,
l5_0.last_update_time,
l5_0.NAME,
l5_0.order_nr,
et3_0.order_nr,
et3_0.parent_id,
lh2_0.last_update_time,
lh2_0.NAME,
lh2_0.opening_date,
lh2_0.paybird_config,
a1_0.min_funding_amount,
a1_0.min_sweeping_amount,
a1_0.NAME,
a1_0.opening_date,
a1_0.operational_holder_id,
oh2_0.id,
oh2_0.alternative_name,
oh2_0.business_id,
oh2_0.closing_date,
oh2_0.code,
oh2_0.creation_time,
c6_0.id,
c6_0.creation_time,
c6_0.last_message,
c6_0.last_update_time,
c6_0.NAME,
c6_0.PRECISION,
c6_0.status,
c6_0.system_managed,
et4_0.id,
et4_0.creation_time,
et4_0.description,
et4_0.item,
et4_0.last_update_time,
et4_0.level_id,
l6_0.id,
l6_0.creation_time,
l6_0.last_update_time,
l6_0.NAME,
l6_0.order_nr,
et4_0.order_nr,
et4_0.parent_id,
oh2_0.last_update_time,
oh2_0.NAME,
oh2_0.opening_date,
oh2_0.paybird_config,
a1_0.paybird_config,
a1_0.period_lock_end_date,
a1_0.target_balance,
tps2_0.id,
tps2_0.configuration,
tps2_0.creation_time,
tps2_0.disabled,
tps2_0.last_update_time,
tps2_0.NAME,
tps2_0.system_managed,
tps2_0.type,
acp1_0.cauliflower_pool,
cp1_0.id,
cp1_0.creation_time,
c7_0.id,
c7_0.creation_time,
c7_0.last_message,
c7_0.last_update_time,
c7_0.NAME,
c7_0.PRECISION,
c7_0.status,
c7_0.system_managed,
cp1_0.last_update_time,
cp1_0.NAME,
cp1_0.status,
cp1_0.type,
acp1_0.type
FROM account_cauliflower_pool acp1_0
JOIN account a1_0
ON a1_0.id = acp1_0.account
LEFT JOIN account_type at1_0
ON at1_0.id = a1_0.account_type_id
LEFT JOIN account_type_level l1_0
ON l1_0.id = at1_0.level_id
LEFT JOIN connector_instance bps1_0
ON bps1_0.id = a1_0.balances_preferred_source_id
AND bps1_0.deleted = false
LEFT JOIN connector_instance_feature f1_0
ON bps1_0.id = f1_0.instance_id
AND f1_0.deleted = false
LEFT JOIN barron_branch bb1_0
ON bb1_0.id = a1_0.barron_branch_id
LEFT JOIN barron b1_0
ON b1_0.id = bb1_0.bank_id
JOIN currency c1_0
ON c1_0.id = a1_0.currency_id
LEFT JOIN account ima1_0
ON ima1_0.id = a1_0.ihb_mirroring_account_id
LEFT JOIN account_type at2_0
ON at2_0.id = ima1_0.account_type_id
LEFT JOIN account_type_level l2_0
ON l2_0.id = at2_0.level_id
LEFT JOIN connector_instance bps2_0
ON bps2_0.id = ima1_0.balances_preferred_source_id
AND bps2_0.deleted = false
LEFT JOIN barron_branch bb2_0
ON bb2_0.id = ima1_0.barron_branch_id
LEFT JOIN barron b2_0
ON b2_0.id = bb2_0.bank_id
LEFT JOIN currency c2_0
ON c2_0.id = ima1_0.currency_id
LEFT JOIN entity lh1_0
ON lh1_0.id = ima1_0.legal_holder_id
LEFT JOIN currency c3_0
ON c3_0.id = lh1_0.currency_id
LEFT JOIN entity_type et1_0
ON et1_0.id = lh1_0.entity_type_id
LEFT JOIN entity_type_level l3_0
ON l3_0.id = et1_0.level_id
LEFT JOIN entity oh1_0
ON oh1_0.id = ima1_0.operational_holder_id
LEFT JOIN currency c4_0
ON c4_0.id = oh1_0.currency_id
LEFT JOIN entity_type et2_0
ON et2_0.id = oh1_0.entity_type_id
LEFT JOIN entity_type_level l4_0
ON l4_0.id = et2_0.level_id
LEFT JOIN connector_instance tps1_0
ON tps1_0.id = ima1_0.transactions_preferred_source_id
AND tps1_0.deleted = false
LEFT JOIN entity lh2_0
ON lh2_0.id = a1_0.legal_holder_id
LEFT JOIN currency c5_0
ON c5_0.id = lh2_0.currency_id
LEFT JOIN entity_type et3_0
ON et3_0.id = lh2_0.entity_type_id
LEFT JOIN entity_type_level l5_0
ON l5_0.id = et3_0.level_id
JOIN entity oh2_0
ON oh2_0.id = a1_0.operational_holder_id
LEFT JOIN currency c6_0
ON c6_0.id = oh2_0.currency_id
LEFT JOIN entity_type et4_0
ON et4_0.id = oh2_0.entity_type_id
LEFT JOIN entity_type_level l6_0
ON l6_0.id = et4_0.level_id
LEFT JOIN connector_instance tps2_0
ON tps2_0.id = a1_0.transactions_preferred_source_id
AND tps2_0.deleted = false
JOIN cauliflower_pool cp1_0
ON cp1_0.id = acp1_0.cauliflower_pool
LEFT JOIN currency c7_0
ON c7_0.id = cp1_0.currency_id
WHERE acp1_0.account = ?
SELECT bb1_0.id,
b1_0.id,
b1_0.bic,
b1_0.business_id,
b1_0.city,
b1_0.country,
b1_0.creation_time,
b1_0.last_update_time,
b1_0.NAME,
b1_0.paybird_config,
b1_0.postal_code,
b1_0.street,
bb1_0.bic,
bb1_0.business_id,
bb1_0.city,
bb1_0.country,
bb1_0.creation_time,
bb1_0.last_update_time,
bb1_0.NAME,
bb1_0.paybird_config,
bb1_0.postal_code,
bb1_0.street,
bb1_0.time_zone
FROM barron_branch bb1_0
LEFT JOIN barron b1_0
ON b1_0.id = bb1_0.bank_id
WHERE bb1_0.id = ?
SELECT e1_0.id,
e1_0.alternative_name,
e1_0.business_id,
e1_0.closing_date,
e1_0.code,
e1_0.creation_time,
c1_0.id,
c1_0.creation_time,
c1_0.last_message,
c1_0.last_update_time,
c1_0.NAME,
c1_0.PRECISION,
c1_0.status,
c1_0.system_managed,
et1_0.id,
et1_0.creation_time,
et1_0.description,
et1_0.item,
et1_0.last_update_time,
et1_0.level_id,
l1_0.id,
l1_0.creation_time,
l1_0.last_update_time,
l1_0.NAME,
l1_0.order_nr,
et1_0.order_nr,
et1_0.parent_id,
e1_0.last_update_time,
e1_0.NAME,
e1_0.opening_date,
e1_0.paybird_config
FROM entity e1_0
LEFT JOIN currency c1_0
ON c1_0.id = e1_0.currency_id
LEFT JOIN entity_type et1_0
ON et1_0.id = e1_0.entity_type_id
LEFT JOIN entity_type_level l1_0
ON l1_0.id = et1_0.level_id
WHERE e1_0.id = ?
Basically , cauliflower_pool has back reference to Account.
And ihb account is reference to other row from returned accounts.
