Unir dos consultas MySQL

[gnzsoloyo]

No en esa forma, pero se podría usando subconsultas en el FROM:

Código MySQL:

SELECT S.Id, P.Id, P.IdSite, P.Title 
FROM 
    (SELECT Id FROM site WHERE IdSiteCategories = 5 AND `STATUS`= 1 ORDER BY TotalRatio DESC LIMIT 5) S 
    INNER JOIN 
    (SELECT Id, IdSite, Title FROM post WHERE `STATUS`= 1 AND IdPostCategories IN (2,4,5) ORDER BY Ratio LIMIT 10) P 
    ON S.Id = P.IdSite
ORDER BY S.TotalRatio ASC, P.Ratio DESC;