Title: jedait's Replies | WordPress.org

---

# jedait

  [  ](https://wordpress.org/support/users/jedait/)

 *   [Profile](https://wordpress.org/support/users/jedait/)
 *   [Topics Started](https://wordpress.org/support/users/jedait/topics/)
 *   [Replies Created](https://wordpress.org/support/users/jedait/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/jedait/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/jedait/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/jedait/engagements/)
 *   [Favorites](https://wordpress.org/support/users/jedait/favorites/)

 Search replies:

## Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Definition List] [Plugin: Definition List] Plugin's page is in Russian](https://wordpress.org/support/topic/plugin-definition-list-plugins-page-is-in-russian/)
 *  Plugin Author [jedait](https://wordpress.org/support/users/jedait/)
 * (@jedait)
 * [15 years, 10 months ago](https://wordpress.org/support/topic/plugin-definition-list-plugins-page-is-in-russian/#post-1591981)
 * Just add **English translation** to the _Plugin Page_.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [How to Exclude Pages in Popularity Contest?](https://wordpress.org/support/topic/popularity-contest-1/)
 *  [jedait](https://wordpress.org/support/users/jedait/)
 * (@jedait)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/popularity-contest-1/#post-1249228)
 * You can remove posts with ‘page’ type directly from SQL query.
    Add this:
 *  AND post_type = ‘post’
 * on line 1938. You’ll get something like this:
 *     ```
       function get_top_ranked_posts($limit) {
               global $wpdb;
               $temp = $wpdb;
   
               $join = apply_filters('posts_join', '');
               $where = apply_filters('posts_where', '');
               $groupby = apply_filters('posts_groupby', '');
               if (!empty($groupby)) {
                   $groupby = ' GROUP BY '.$groupby;
               }
               else {
                   $groupby = ' GROUP BY '.$wpdb->posts.'.ID ';
               }
   
               $posts = $wpdb->get_results("
                   SELECT ID, post_title
                   FROM $wpdb->posts
                   LEFT JOIN $wpdb->ak_popularity pop
                   ON $wpdb->posts.ID = pop.post_id
                   $join
                   WHERE post_status = 'publish'
                   AND post_date < NOW()
                       AND post_type = 'post'
                   $where
                   $groupby
                   ORDER BY pop.total DESC
                   LIMIT ".intval($limit)
               );
       ```
   
 * Personally I use _akpc\_most\_popular()_ function to get popular posts. And it
   transitively calls _get\_top\_ranked\_posts()_.

Viewing 2 replies - 1 through 2 (of 2 total)