---

SELECT
    ppf.pens_product_id,
    ppf.type_group_form_id,
    tgf.doc_type,
    lf.id AS landscape_form_id,
    lf.code,
    lf.start_date,
    lf.end_date,
    lf.filename
FROM prod_line.pens_product_hb_print_form ppf
LEFT JOIN ourpension.type_group_form tgf
    ON tgf.id = ppf.type_group_form_id
LEFT JOIN ourpension.landscape_form lf
    ON lf.type_group_form_id = ppf.type_group_form_id
WHERE ppf.pens_product_id = 9244
ORDER BY
    ppf.type_group_form_id,
    lf.start_date DESC;