select media_name.name,media_hot.hot from media_name inner join media_hot on media_hot.id=media_name.id order by hot desc
根据media_hot表中id,hot项的Hot倒序输出media_name的name及hot
