jaavid

🙂

global $wpdb;
$results = $wpdb -> get_results('SELECT wp_statistics_pages.id
FROM wp_statistics_pages
JOIN wp_posts
ON wp_posts.ID = wp_statistics_pages.id
WHERE wp_posts.post_type = 'publication'
GROUP BY id
ORDER BY count
DESC
LIMIT 10', ARRAY_A );

$args = array(
'post_type'  => 'publication',
'post__in'  => $results,
'orderby'   => 'post__in'
);
$query = new WP_Query( $args );