get_results( 'SELECT' . ' COUNT(*) AS count,' . ' u.display_name AS name,' . ' u.user_url AS url,' . ' u.user_nicename AS nicename' . ' FROM ' . $wpdb->posts . ' p' . ' LEFT JOIN ' . $wpdb->users . ' u ON p.post_author = u.ID' . ' WHERE post_status=\'publish\'' . ' AND post_type=\'post\'' . ' GROUP BY post_author' . ' ORDER BY count DESC', OBJECT ); if ( !empty( $authorRanking ) ): ?>