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]
SELECT SQL_CALC_FOUND_ROWS www_posts.ID FROM www_posts INNER JOIN www_postmeta ON ( www_posts.ID = www_postmeta.post_id ) INNER JOIN www_postmeta AS mt1 ON ( www_posts.ID = mt1.post_id ) INNER JOIN www_postmeta AS mt2 ON ( www_posts.ID = mt2.post_id ) INNER JOIN www_postmeta AS mt3 ON ( www_posts.ID = mt3.post_id ) WHERE 1=1 AND ( www_postmeta.meta_key = 'cmd_display_priority' AND ( ( mt1.meta_key = 'cmd_start_date' AND mt1.meta_value <= '2026-03-09' ) AND ( ( mt2.meta_key = 'cmd_valid_till' AND mt2.meta_value >= '2026-03-09' ) OR ( mt2.meta_key = 'cmd_valid_till' AND mt2.meta_value = '' ) ) AND ( ( mt3.meta_key = 'cmd_type' AND mt3.meta_value = 'deal' ) ) ) ) AND ((www_posts.post_type = 'coupons' AND (www_posts.post_status = 'publish'))) GROUP BY www_posts.ID ORDER BY www_postmeta.meta_value+0 DESC LIMIT 0, 20

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]
SELECT SQL_CALC_FOUND_ROWS www_posts.ID FROM www_posts INNER JOIN www_postmeta ON ( www_posts.ID = www_postmeta.post_id ) INNER JOIN www_postmeta AS mt1 ON ( www_posts.ID = mt1.post_id ) INNER JOIN www_postmeta AS mt2 ON ( www_posts.ID = mt2.post_id ) INNER JOIN www_postmeta AS mt3 ON ( www_posts.ID = mt3.post_id ) WHERE 1=1 AND ( www_postmeta.meta_key = 'cmd_display_priority' AND ( ( mt1.meta_key = 'cmd_start_date' AND mt1.meta_value <= '2026-03-09' ) AND ( ( mt2.meta_key = 'cmd_valid_till' AND mt2.meta_value >= '2026-03-09' ) OR ( mt2.meta_key = 'cmd_valid_till' AND mt2.meta_value = '' ) ) AND ( ( mt3.meta_key = 'cmd_type' AND mt3.meta_value = 'code' ) ) ) ) AND ((www_posts.post_type = 'coupons' AND (www_posts.post_status = 'publish'))) GROUP BY www_posts.ID ORDER BY www_postmeta.meta_value+0 DESC LIMIT 0, 20