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;