MYSQL从两行中随机选择

Question

有人可以帮助我解决这个问题。 我有这个表样本：

文件表

• UID
• 文件
• uploaded_on_date
• VIEW_COUNT

我要考虑的是前30名最最近上传的文件和前30名最多浏览文件然后从他们随机选择和限制10。

我是新来的这个mysql复杂查询。示例查询会很好，我将能够理解它。 谢谢。

Answer 1

SELECT 
    * 
FROM 
(
SELECT 
    * 
FROM 
    tablefile 
ORDER BY 
    uploaded_on_date DESC 
LIMIT 30 
UNION SELECT 
* 
FROM 
    tablefile 
ORDER BY 
    view_count DESC 
LIMIT 30 
) 
ORDER BY 
    RAND() 
LIMIT 10; 

Answer 2

select * from (
    select * from table order by upload_on_date desc limit 30 
    union 
    select * from table order by view_count desc limit 30) t 
order by rand() limit 10