SELECT
    ...
FROM
    company c,
    INNER JOIN team t,
    INNER JOIN user u,
    ...
WHERE (c.trashed = 0)
    AND (t.trashed = 0)
    AND (u.trashed = 0)
    AND (opp.fee_total_value = 10000)
    OR (opp.fee_total_value > 5000)
    --AND (c.trashed = 0)
    --AND (t.trashed = 0)
    --AND (u.trashed = 0)
    AND (opp.fee_total_value < 6000)
    OR (opp.fee_total_value > 8000)
    --AND (c.trashed = 0)
    --AND (t.trashed = 0)
    --AND (u.trashed = 0)
    AND (opp.fee_total_value < 9000)
ORDER BY ...