SELECT b.name
FROM brands b
INNER JOIN products p
    ON b.id = p.brand_id
INNER JOIN transaction_sell_lines tr
    ON p.brand_id=tr.product_id