Title: SQL error on prod filter
Last modified: December 1, 2023

---

# SQL error on prod filter

 *  Resolved [nomadicdev](https://wordpress.org/support/users/nomadicdev/)
 * (@nomadicdev)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-prod-filter/)
 * I’m getting this following SQL error because this plugin seems to be setting 
   LIMIT 0, -1 on all filters I add. Any ideas / help?
   **WordPress database error:**[
   You have an error in your SQL syntax; check the manual that corresponds to your
   MariaDB server version for the right syntax to use near ‘-1’ at line 27]`SELECT
   SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships
   ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships
   AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2
   ON (wp_posts.ID = tt2.object_id) LEFT JOIN wp_term_relationships AS tt3 ON (wp_posts.
   ID = tt3.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id
   AND wp_postmeta.meta_key = 'wcu_currency_unavailable_GBP' ) WHERE 1=1 AND ( (
   wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id
   IN (7) ) ) AND ( wp_term_relationships.term_taxonomy_id IN (121,122,125,126,231)
   AND tt1.term_taxonomy_id IN (34,119) ) AND tt2.term_taxonomy_id IN (91) AND tt3.
   term_taxonomy_id IN (91) ) AND ( wp_postmeta.post_id IS NULL ) AND ((wp_posts.
   post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status
   = 'acf-disabled' OR wp_posts.post_status = 'private'))) GROUP BY wp_posts.ID 
   ORDER BY wp_posts.ID ASC LIMIT 0, -1`

Viewing 1 replies (of 1 total)

 *  Plugin Author [WBW Plugins](https://wordpress.org/support/users/woobewoo/)
 * (@woobewoo)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-prod-filter/#post-17258352)
 * Hello [@nomadicdev](https://wordpress.org/support/users/nomadicdev/),
 * Please contact our internal support team.
   Need more information on this issue
   [https://woobewoo.com/contact-us/](https://woobewoo.com/contact-us/)

Viewing 1 replies (of 1 total)

The topic ‘SQL error on prod filter’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/woo-product-filter_a0a6df.svg)
 * [Product Filter for WooCommerce by WBW](https://wordpress.org/plugins/woo-product-filter/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-product-filter/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-product-filter/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-product-filter/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-product-filter/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-product-filter/reviews/)

## Tags

 * [product filter](https://wordpress.org/support/topic-tag/product-filter/)
 * [product search](https://wordpress.org/support/topic-tag/product-search/)

 * 1 reply
 * 2 participants
 * Last reply from: [WBW Plugins](https://wordpress.org/support/users/woobewoo/)
 * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-prod-filter/#post-17258352)
 * Status: resolved