---

SELECT
    p.brief AS param_brief,
    p.name AS param_name,
    pt.*
FROM prod_line.pens_product_param_pl ppp
JOIN prod_line.param_pl p
    ON p.id = ppp.param_pl_id
JOIN prod_line.table_param_pl_payment_term pt
    ON pt.pens_product_param_pl_id = ppp.id
WHERE ppp.pens_product_id = 6693
ORDER BY pt.id;