Title: SQL Where problem
Last modified: June 4, 2025

---

# SQL Where problem

 *  Resolved [jkacher](https://wordpress.org/support/users/jkacher/)
 * (@jkacher)
 * [1 year ago](https://wordpress.org/support/topic/sql-where-problem/)
 * In the Application I specified a view as data source, which had 6000 records,
   in the Where clause reducing it to 4000 records. The returned data had my 4000
   records PLUS 2000 blank records.

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year ago](https://wordpress.org/support/topic/sql-where-problem/#post-18499482)
 * Hi [@jkacher](https://wordpress.org/support/users/jkacher/),
 * Thanks for the post.
 * What condition was in the WHERE clause?
 * Is Enable Large Table Support selected? Could you try disabling it in Table Builder
   > Performance?
 * See here: [https://share.zight.com/6qup1xBo](https://share.zight.com/6qup1xBo)
 * We’ll wait for your response.

Viewing 1 replies (of 1 total)

The topic ‘SQL Where problem’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [1 year ago](https://wordpress.org/support/topic/sql-where-problem/#post-18499482)
 * Status: resolved