Загрузка данных


SELECT
    cp.contract_id,
    cp.form_id,
    lf.id AS landscape_form_id,
    lf.code AS landscape_form_code,
    lf.filename
FROM ourpension.contract_params cp
LEFT JOIN ourpension.landscape_form lf
    ON lf.id = cp.form_id
WHERE cp.form_id IS NOT NULL
LIMIT 50;





SELECT
    count(*) AS form_id_count,
    count(lf.id) AS landscape_form_match_count
FROM ourpension.contract_params cp
LEFT JOIN ourpension.landscape_form lf
    ON lf.id = cp.form_id
WHERE cp.form_id IS NOT NULL;