SQL Where problem | WordPress.org

Resolved jkacher
(@jkacher)

8 months, 2 weeks ago

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
(@kimmyx)

8 months, 2 weeks ago

Hi @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

We’ll wait for your response.

Viewing 1 replies (of 1 total)

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

1 reply
2 participants
Last reply from: Kim L
Last activity: 8 months, 2 weeks ago
Status: resolved