WordPress database error: [Unknown column 'i.item_value_num' in 'field list']
SELECT
MIN(i.item_value_num) AS min,
MAX(i.item_value_num) AS max
FROM wp_jet_smart_filters_indexer i
INNER JOIN ( SELECT wp_posts.*
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)
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (79)
)
AND
wp_term_relationships.term_taxonomy_id IN (23,26,50)
AND
tt1.term_taxonomy_id IN (23,26,50)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
) q
ON q.ID = i.item_id
WHERE i.item_key = 'hot_tub_seats'
AND i.type = 'post'
AND i.item_value_num IS NOT NULL
/* From [spapalace.com/product-category/hot-tubs/] in [/nas/content/live/spapalace/wp-content/plugins/jet-smart-filters/includes/functions.php:159] */
WordPress database error: [Unknown column 'i.item_value_num' in 'field list']
SELECT
MIN(i.item_value_num) AS min,
MAX(i.item_value_num) AS max
FROM wp_jet_smart_filters_indexer i
INNER JOIN ( SELECT wp_posts.*
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)
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (79)
)
AND
wp_term_relationships.term_taxonomy_id IN (23,26,50)
AND
tt1.term_taxonomy_id IN (23,26,50)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
) q
ON q.ID = i.item_id
WHERE i.item_key = 'hot_tub_jet_count'
AND i.type = 'post'
AND i.item_value_num IS NOT NULL
/* From [spapalace.com/product-category/hot-tubs/] in [/nas/content/live/spapalace/wp-content/plugins/jet-smart-filters/includes/functions.php:159] */
WordPress database error: [Unknown column 'i.item_value_num' in 'field list']
SELECT
MIN(i.item_value_num) AS min,
MAX(i.item_value_num) AS max
FROM wp_jet_smart_filters_indexer i
INNER JOIN ( SELECT wp_posts.*
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)
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (79)
)
AND
wp_term_relationships.term_taxonomy_id IN (23,26,50)
AND
tt1.term_taxonomy_id IN (23,26,50)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
) q
ON q.ID = i.item_id
WHERE i.item_key = 'spa_palace_sale_price_format'
AND i.type = 'post'
AND i.item_value_num IS NOT NULL
/* From [spapalace.com/product-category/hot-tubs/] in [/nas/content/live/spapalace/wp-content/plugins/jet-smart-filters/includes/functions.php:159] */
