Title: ellision's Replies | WordPress.org

---

# ellision

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

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

 Search replies:

## Forum Replies Created

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

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [how to page custom database query (to sort by custom field)?](https://wordpress.org/support/topic/how-to-page-custom-database-query-to-sort-by-custom-field/)
 *  [ellision](https://wordpress.org/support/users/ellision/)
 * (@ellision)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/how-to-page-custom-database-query-to-sort-by-custom-field/page/2/#post-746286)
 *     ```
       <?php
       $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
       $postsperpage = 30;
       $offset = ($paged-1) * $postsperpage
       $pageposts = $wpdb->get_results("SELECT wposts.*
       FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
       WHERE ... blah ...
       LIMIT $offset, $posts_per_page ", OBJECT);
       ...
       foreach ($posts as $post) :
       setup_postdata($post); ?>
           (loop stuff)
       <?php endforeach; ?>
       ```
   
 * Yeah, this works very well!
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Paging Custom Page Template](https://wordpress.org/support/topic/paging-custom-page-template/)
 *  [ellision](https://wordpress.org/support/users/ellision/)
 * (@ellision)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/paging-custom-page-template/#post-699844)
 * an example
 *     ```
       <?php
       $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
       $postsperpage = 30;
       $offset = ($paged-1) * $postsperpage
       $pageposts = $wpdb->get_results("SELECT wposts.*
       FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
       WHERE ... blah ...
       LIMIT $offset, $posts_per_page ", OBJECT);
       ...
       foreach ($posts as $post) :
       setup_postdata($post); ?>
           (loop stuff)
       <?php endforeach; ?>
       ```
   
 * works well in my site

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