Title: InnerJoin and Filtering
Last modified: April 22, 2020

---

# InnerJoin and Filtering

 *  Resolved [yarsky](https://wordpress.org/support/users/yarsky/)
 * (@yarsky)
 * [6 years ago](https://wordpress.org/support/topic/innerjoin-and-filtering/)
 * Creating table:
    SELECT posts_page.post_title AS page_post_title, posts_page.
   post_type AS page_post_type, wp_users.display_name as user FROM wp_posts AS posts_page
   inner join wp_users on wp_users.id = posts_page.post_author WHERE 1=1 AND posts_page.
   post_type = ‘page’
 * Config filter to ‘selectbox’ on column `user`
 * Error in log:
    Unknown column ‘wp_posts.user’ in ‘where clause’ for query SELECT
   SQL_CALC_FOUND_ROWS posts_page.post_title AS page_post_title, posts_page.post_type
   AS page_post_type, wp_users.display_name AS user FROM wp_posts AS posts_page 
   INNER JOIN wp_users ON wp_users.id = posts_page.post_author WHERE 1 = 1 AND posts_page.
   post_type = ‘page’ AND `wp_posts`.`user` LIKE ‘%admin%’ ORDER BY `page_post_title`
   ASC LIMIT 10

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [6 years ago](https://wordpress.org/support/topic/innerjoin-and-filtering/#post-12715318)
 * Hello there.
 * We’re sorry, but editing and SQL Query based tables are not included in the Lite(
   free) version of the plugin, so we cannot provide any support for those through
   this forum.
 * Please feel free to open a ticket on our official support platform (accessible
   from our official website), and we’ll gladly help you out there.
 * Even if your support expired, you can open a **pre-purchase** ticket where a 
   purchase code is not required, so our support managers can help you out with 
   this.
 * Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘InnerJoin and Filtering’ is closed to new replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/innerjoin-and-filtering/#post-12715318)
 * Status: resolved