Thread: Refine Results Bug

WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query SELECT SQL_CALC_FOUND_ROWS  wpark_posts.ID FROM wpark_posts  INNER JOIN wpark_term_relationships ON (wpark_posts.ID = wpark_term_relationships.object_id) INNER JOIN wpark_postmeta ON (wpark_posts.ID = wpark_postmeta.post_id)
INNER JOIN wpark_postmeta AS mt1 ON (wpark_posts.ID = mt1.post_id)
INNER JOIN wpark_postmeta AS mt2 ON (wpark_posts.ID = mt2.post_id)
INNER JOIN wpark_postmeta AS mt3 ON (wpark_posts.ID = mt3.post_id)
INNER JOIN wpark_postmeta AS mt4 ON (wpark_posts.ID = mt4.post_id)
INNER JOIN wpark_postmeta AS mt5 ON (wpark_posts.ID = mt5.post_id)
INNER JOIN wpark_postmeta AS mt6 ON (wpark_posts.ID = mt6.post_id)
INNER JOIN wpark_postmeta AS mt7 ON (wpark_posts.ID = mt7.post_id) WHERE 1=1  AND ( wpark_term_relationships.term_taxonomy_id IN (24) ) AND wpark_posts.post_type = 'ad_listing' AND (wpark_posts.post_status = 'publish' OR wpark_posts.post_status = 'tr_pending' OR wpark_posts.post_status = 'tr_failed' OR wpark_posts.post_status = 'tr_completed' OR wpark_posts.post_status = 'tr_activated' OR wpark_posts.post_status = 'private') AND ( (wpark_postmeta.meta_key = 'cp_sale_01' AND CAST(wpark_postmeta.meta_value AS CHAR) IN ('電梯大樓'))
AND  (mt1.meta_key = 'cp_sale_03' AND CAST(mt1.meta_value AS CHAR) IN ('3 房'))
AND  (mt2.meta_key = 'cp_sale_04' AND CAST(mt2.meta_value AS CHAR) IN ('2 廳'))
AND  (mt3.meta_key = 'cp_sale_05' AND CAST(mt3.meta_value AS CHAR) IN ('2 衛'))
AND  (mt4.meta_key = 'cp_sale_17' AND CAST(mt4.meta_value AS CHAR) IN ('5-10 年'))
AND  (mt5.meta_key = 'cp_sale_12' AND CAST(mt5.meta_value AS CHAR) IN ('30-40 坪'))
AND  (mt6.meta_key = 'cp_sale_13' AND CAST(mt6.meta_value AS CHAR) IN ('平面式停車位'))
AND  (mt7.meta_key = 'cp_sale_16' AND CAST(mt7.meta_value AS CHAR) IN ('尚未裝潢')) ) GROUP BY wpark_posts.ID ORDER BY wpark_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts