---

-- Структура proclog
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = '_delete_lkul'
  AND table_name = 'proclog'
ORDER BY ordinal_position;




-- Когда именно были созданы payment-записи для документа 176
SELECT 
    p.id,
    p.accrual_repurchase_id,
    p.payment_register_id,
    p.topay
FROM back_office.payment p
JOIN back_office.accrual_repurchase_amount_payments_details d 
  ON d.id = p.accrual_repurchase_id
WHERE d.accrual_repurchase_amount_payments_id = 176
  AND p.payment_register_id IS NOT NULL
LIMIT 3;