[MySql] - Ordinare tabella

[clasku]

se ho capito bene, credo tu debba usare una union

select * from (SELECT * FROM tuaTabella where type = 7 order by percent desc, date desc)  as a
union all
select * from (SELECT * FROM tuaTabella where type != 7 order by percent desc, date desc)  as b;