
Originariamente inviata da
clasku
se ho capito bene, credo tu debba usare una union
codice:
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;