Przydatne

SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )LEFT JOIN wp_term_relationships tr ON wp_posts.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN wp_terms t ON t.term_id = tt.term_id WHERE 1=1 AND ( wp_postmeta.meta_key = 'last_name' ) AND wp_posts.post_type = 'doctor' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY t.name COLLATE utf8_polish_ci DESC LIMIT 0, 25