Empty response since WordPress 6.0.0

[marcinkieruzel]

After upgrading to WordPress 6.0.0 I get an empty response from query.

with 6.0.0 request in wp_query looks like:

"\n\t\t\tSELECT SQL_CALC_FOUND_ROWS  prx23_posts.*\n\t\t\tFROM prx23_posts \n\t\t\t \n\t\t\t\n\t\t\tORDER BY tables.post_date DESC\n\t\t\tLIMIT 0, 10\n\t\t"

with 5.9.4 like:

"SELECT SQL_CALC_FOUND_ROWS  tables.* FROM (  SELECT prx23_posts.*, '1' as site_ID FROM prx23_posts  WHERE 1=1  AND ((prx23_posts.post_type = 'news' AND (prx23_posts.post_status = 'publish' OR prx23_posts.post_status = 'acf-disabled')))  UNION  SELECT prx23_9_posts.*, '9' as site_ID FROM prx23_9_posts  WHERE 1=1  AND ((prx23_9_posts.post_type = 'news' AND (prx23_9_posts.post_status = 'publish' OR prx23_9_posts.post_status = 'acf-disabled')))  UNION  SELECT prx23_10_posts.*, '10' as site_ID FROM prx23_10_posts  WHERE 1=1  AND ((prx23_10_posts.post_type = 'news' AND (prx23_10_posts.post_status = 'publish' OR prx23_10_posts.post_status = 'acf-disabled')))  UNION  SELECT prx23_11_posts.*, '11' as site_ID FROM prx23_11_posts  WHERE 1=1  AND ... 

It happens to all of this plugin popular forks:
https://github.com/ericandrewlewis/WP_Query_Multisite
https://github.com/miguelpeixe/WP_Query_Multisite
https://github.com/timothyjensen/wp-query-multisite

[valakia]

Any solutions to this problem? I just encountered it too but haven't delved deeper into it yet. I get a database error concerning the orderby for tables...