Next time you ask a question do not only say "does not work", but explain what you mean by that. Particularly, include any error message you get.
As it happens, I can see the error directly this time. In an UNION query, the ORDER BY clause applies to the full UNION query; you cannot have ORDER BY clauses for each query. This might be query you want:
select coluna1, coluna2, coluna3, coluna4,coluna5 as produto, sum(coluna6) coluna6, min(coluna7) as coluna7, max(coluna8) as coluna8, coluna9, coluna10
from view
where coluna5 in ('prod1',
'prod2',
'prod3')
and coluna1 is not null
group by coluna1, coluna2, coluna3, coluna4,coluna5, coluna9, coluna10
UNION ALL
select coluna1, coluna2, coluna3, coluna4,coluna5 as produto, max(coluna6) coluna6, min(coluna7nova) as coluna7, max(coluna8nova) as coluna8, coluna9, coluna10
from view
where coluna5 in ('prod4',
'prod5',
'prod6')
and coluna1 is not null
group by coluna1, coluna2, coluna3, coluna4,coluna5, coluna9, coluna10
order by coluna1, coluna2, coluna4,coluna5, coluna7
I changed UNION to UNION ALL, because that is what want most of the time. UNION remove duplicates which takes resources. And you may want to retain the duplicates.