SQL语句如下:
select top 16 * from View_product WHERE isPassAudit='true' and pagerRank0>0 ORDER BY pagerrank0 DESC, case when datediff(day,releaseTime,getdate())=0 then 1 else 0 end desc,case when ISNUMERIC(price)=1 then '3' when price<>'' then '2' else '1' end desc ,releaseTime desc,productid descselect top 16 * from View_prod