SELECT 
    PO.ID, 
    PO.post_title, 
    PO.post_author,
    CA.meta_value as 'categoria',
    MC.meta_value as 'minerva_categoria',
    MG.meta_value as 'minerva_geral',
    VC.meta_value as 'votos_categoria',
    VG.meta_value as 'votos_geral'
FROM psj_posts PO
LEFT JOIN psj_postmeta AS CA ON CA.post_id = PO.ID AND CA.meta_key = 'categoria'
LEFT JOIN psj_postmeta AS VC ON VC.post_id = PO.ID AND VC.meta_key = 'vencedor_categoria_total_votos'
LEFT JOIN psj_postmeta AS VG ON VG.post_id = PO.ID AND VG.meta_key = 'vencedor_geral_total_votos'
LEFT JOIN psj_postmeta AS MC ON MC.post_id = PO.ID AND MC.meta_key = 'voto_minerva_categoria'
LEFT JOIN psj_postmeta AS MG ON MG.post_id = PO.ID AND MG.meta_key = 'voto_minerva_geral'
ORDER BY VC.meta_value DESC, VG.meta_value DESC;