WP query based on two meta queries

You have to turn off sql_mode=only_full_group_by on your server via an SQL command

e.g. https://stackoverflow.com/a/36568545/57482