---

SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
  AND table_name = 'posted_register_details'
ORDER BY ordinal_position




SELECT prd.contract_id, prd.operation_id, COUNT(*)
FROM back_office.posted_register_details prd
JOIN back_office.eps_transaction_source ets
    ON ets.operation_id = prd.operation_id
GROUP BY prd.contract_id, prd.operation_id
LIMIT 10