---

SELECT
    old_ps.id AS old_scheme_id,
    old_ps.number AS old_scheme_number,
    old_ps.name AS old_scheme_name,
    old_ps.prod_line_pens_scheme_id,
    new_ps.id AS new_scheme_id,
    new_ps.name AS new_scheme_name,
    new_ps.index_scheme,
    new_ps.uid_1c
FROM ourpension.pension_scheme old_ps
LEFT JOIN prod_line.pens_scheme new_ps
    ON new_ps.id = old_ps.prod_line_pens_scheme_id
WHERE old_ps.id IN (8968, 8969, 8971)
ORDER BY old_ps.id;