WordPress-Datenbank-Fehler: [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 wp_phb_posts.ID, CAST( orderby_event_date_meta.meta_value AS DATETIME ) AS event_date, CAST( orderby_event_duration_meta.meta_value AS DECIMAL ) AS event_duration FROM wp_phb_posts LEFT JOIN wp_phb_term_relationships ON (wp_phb_posts.ID = wp_phb_term_relationships.object_id) LEFT JOIN wp_phb_term_relationships AS tt1 ON (wp_phb_posts.ID = tt1.object_id) LEFT JOIN wp_phb_term_relationships AS tt2 ON (wp_phb_posts.ID = tt2.object_id) LEFT JOIN wp_phb_term_relationships AS tt3 ON (wp_phb_posts.ID = tt3.object_id) LEFT JOIN wp_phb_term_relationships AS tt4 ON (wp_phb_posts.ID = tt4.object_id) INNER JOIN wp_phb_postmeta ON ( wp_phb_posts.ID = wp_phb_postmeta.post_id ) LEFT JOIN wp_phb_postmeta AS orderby_event_date_meta ON ( orderby_event_date_meta.post_id = wp_phb_posts.ID AND orderby_event_date_meta.meta_key = '_EventStartDate' ) LEFT JOIN wp_phb_postmeta AS orderby_event_duration_meta ON ( orderby_event_duration_meta.post_id = wp_phb_posts.ID AND orderby_event_duration_meta.meta_key = '_EventDuration' ) WHERE 1=1 AND wp_phb_posts.ID NOT IN (19841,21852,19848,21881,20911,22212,22749,22750,22001) AND ( wp_phb_term_relationships.term_taxonomy_id IN (23,30,31,92,169,282,283,284,285,286,287,288,289,290,291,292,293,294,304,309,313,314,315,316,390,391,392,468,469,470,471,472,473,474,540,614,615,616) AND ( tt1.term_taxonomy_id IN (23,30,31,92,169,282,283,284,285,286,287,288,289,290,291,292,293,294,304,309,313,314,315,316,390,391,392,468,469,470,471,472,473,474,540,614,615,616) AND tt2.term_taxonomy_id IN (23,30,31,92,169,282,283,284,285,286,287,288,289,290,291,292,293,294,304,309,313,314,315,316,390,391,392,468,469,470,471,472,473,474,540,614,615,616) AND tt3.term_taxonomy_id IN (23,30,31,92,169,282,283,284,285,286,287,288,289,290,291,292,293,294,304,309,313,314,315,316,390,391,392,468,469,470,471,472,473,474,540,614,615,616) AND tt4.term_taxonomy_id IN (23,30,31,92,169,282,283,284,285,286,287,288,289,290,291,292,293,294,304,309,313,314,315,316,390,391,392,468,469,470,471,472,473,474,540,614,615,616) ) ) AND (((wp_phb_posts.post_title LIKE '%werte%') OR (wp_phb_posts.post_excerpt LIKE '%werte%') OR (wp_phb_posts.post_content LIKE '%werte%'))) AND (wp_phb_posts.post_password = '') AND ( ( wp_phb_postmeta.meta_key = '_EventEndDate' AND CAST(wp_phb_postmeta.meta_value AS DATETIME) > '2025-01-17 15:40:02' ) ) AND wp_phb_posts.post_type = 'tribe_events' AND ((wp_phb_posts.post_status = 'publish')) GROUP BY wp_phb_posts.ID ORDER BY event_date ASC, event_duration ASC, wp_phb_posts.post_title LIKE '%werte%' DESC, wp_phb_posts.post_date ASC LIMIT 0, 7