Added DISTINCT to the query.
The query produced a SUM of the channelrevenue that was equal to the number of rows it fetched from the productquantity table, because of the join.
By adding distinct only 1 row fetched from the query is used.