Сортировка постов по last_name автора в Wordpress

08 марта 2016 - 23:28
$querystr = "
SELECT $wpdb->posts.*
FROM $wpdb->posts
INNER JOIN $wpdb->postmeta ON ( $wpdb->posts.ID = $wpdb->postmeta.post_id )
INNER JOIN $wpdb->usermeta ON ( $wpdb->posts.post_author = $wpdb->usermeta.user_id )
WHERE $wpdb->posts.post_type = 'post'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->usermeta.meta_key = 'last_name'
GROUP BY $wpdb->posts.ID
ORDER BY $wpdb->usermeta.meta_value
"
;
$result = $wpdb->get_results($querystr, OBJECT);

Тэги: