Unión de resultados... SELECT anidado o qué?

[gnzsoloyo]

Esta sería una aproximación algo tosca, pero por acá andaría la cosa:

Código MySQL:

SELECT   
    TR.name, 
    T1.name Categoria, 
    T2.name tipo 
FROM 
    wp_posts  P
    INNER JOIN 
    wp_term_relationships R ON P.ID = R.object_id
    INNER JOIN 
    (SELECT * FROM wp_term_taxonomy WHERE taxonomy = 'category') T1 ON (R.term_taxonomy_id = T1.term_taxonomy_id 
    INNER JOIN 
    (SELECT * FROM wp_term_taxonomy WHERE taxonomy = 'tipo') T2 ON (R.term_taxonomy_id = T1.term_taxonomy_id 
    INNER JOIN 
    wp_terms TR ON (T1.term_id = TR.term_id)  
WHERE 
    P.post_type = 'alojamiento' AND P.post_status = 'publish' AND T.taxonomy IN('tipo', 'category')
ORDER BY 
    T1.name, T2.name ASC;