select nt.nickname,nt.account,nt.pic,nt.ofusername,nt.tagprimes from ( select ... union select ... )nt order by nt.tagprimes desc 这样可以吗?
已解决,如下 --------------- SELECT u.id, u.nickname, u.pic, u.gender, u.ofusername, readgrade.value, u.doreadbook, book.name, u.profile, u.age, u.tagprimes FROM app_user u LEFT JOIN app_source readgrade ON u.readgrade = readgrade.value AND readgrade.stype='readgrade' LEFT JOIN app_book book ON u.doreadbook=book.id WHERE u.tagprimesum%2=0 OR u.tagprimesum%3=0 ORDER BY IF(u.tagprimesum%2=0,1,0) + IF(u.tagprimesum%3=0,1,0) DESC
from (
select ...
union
select ...
)nt order by nt.tagprimes desc
这样可以吗?
---------------
SELECT u.id, u.nickname, u.pic, u.gender, u.ofusername, readgrade.value, u.doreadbook, book.name, u.profile, u.age, u.tagprimes
FROM app_user u
LEFT JOIN app_source readgrade ON u.readgrade = readgrade.value AND readgrade.stype='readgrade'
LEFT JOIN app_book book ON u.doreadbook=book.id
WHERE u.tagprimesum%2=0 OR u.tagprimesum%3=0
ORDER BY IF(u.tagprimesum%2=0,1,0) + IF(u.tagprimesum%3=0,1,0) DESC