Opakující se záznam

SELECT 
    c.id, c.contract_number, c.recipient, c.start_plan,
    co.id, co.company_name,
    of.id AS of_id, of.date_issue AS of_date, of.product_total AS of_total,
    od.id AS od_id, od.date_issue AS od_date, od.product_total AS od_total,
    so.id AS so_id, so.date_issue AS so_date, so.product_total AS so_total,
    iv.id AS iv_id, iv.date_issue AS iv_date, iv.product_total AS iv_total
FROM 
    contracts AS c
LEFT JOIN 
    company AS co ON co.id = c.recipient
LEFT JOIN 
    offers AS of ON of.contract_id = c.id
LEFT JOIN 
    orders AS od ON od.contract_id = c.id
LEFT JOIN 
    shipping_orders AS so ON so.contract_id = c.id
LEFT JOIN 
    invoice AS iv ON iv.contract_id = c.id
WHERE 
    c.id = $id