Weird behaviour of search results view with facets and exposed filters

Sorry for my very very late response! I finally had time to update Facets and Search API. Facets to 8.x-1.0-alpha7 and Search API to 8.x-1.0-beta3. No dev versions because it has to go into production and because of the tedious job of uninstalling and installing and creating everything again. Not something I want to do another time!
Unfortunately the bug is still there. :(
But when I put the same line:

$db_query->getArguments();

into the search function everything works fine again.

I've outputted the query with your line of code. See the image attached.
I'm using MariaDB.

So I used your drupal_set_message with pre tags this time. :) In the search I'm doing the facets counts are correct. I couldn't find any difference in the queries. But when I outputted $db_query at the end of the search function I got two different queries.

This one is wrong:

SELECT t.item_id AS item_id, t.score AS score, t_2.title AS title, CASE WHEN t.word LIKE :like_w0 THEN 1 ELSE 0 END AS w0
FROM 
{search_api_db_actor_text} t
LEFT OUTER JOIN {search_api_db_actor} t_2 ON t.item_id = t_2.item_id
LEFT OUTER JOIN {search_api_db_actor_field_added_legal_states} t_3 ON t.item_id = t_3.item_id
WHERE ( (t.word LIKE :db_condition_placeholder_0 ESCAPE '\\') )AND (field_name IN  (:db_condition_placeholder_1)) AND(( (t_2.field_search_exist_start_end >= :db_condition_placeholder_2) AND (t_2.field_search_exist_end_start <= :db_condition_placeholder_3) AND (t_2.name = :db_condition_placeholder_4) AND (t_3.value = :db_condition_placeholder_5) )AND(( (t.item_id IN  (SELECT t.item_id AS item_id
FROM 
(SELECT t.item_id AS item_id, t.score AS score, CASE WHEN t.word LIKE :like_w0 THEN 1 ELSE 0 END AS w0
FROM 
{search_api_db_actor_text} t
WHERE ( (t.word LIKE :db_condition_placeholder_6 ESCAPE '\\') )AND (field_name IN  (:db_condition_placeholder_7)) 
GROUP BY item_id, score, w0) t)) ))AND( (t_2.field_organization_type = :db_condition_placeholder_6) ))
GROUP BY item_id, score, w0, t_2.title
ORDER BY score DESC, t_2.title ASC
LIMIT 20 OFFSET 0

This one is correct:

SELECT t.item_id AS item_id, t.score AS score, t_2.title AS title, CASE WHEN t.word LIKE :like_w0 THEN 1 ELSE 0 END AS w0
FROM 
{search_api_db_actor_text} t
LEFT OUTER JOIN {search_api_db_actor} t_2 ON t.item_id = t_2.item_id
LEFT OUTER JOIN {search_api_db_actor_field_added_legal_states} t_3 ON t.item_id = t_3.item_id
WHERE ( (t.word LIKE :db_condition_placeholder_0 ESCAPE '\\') )AND (field_name IN  (:db_condition_placeholder_1)) AND(( (t_2.field_search_exist_start_end >= :db_condition_placeholder_2) AND (t_2.field_search_exist_end_start <= :db_condition_placeholder_3) AND (t_2.name = :db_condition_placeholder_4) AND (t_3.value = :db_condition_placeholder_5) )AND(( (t.item_id IN  (SELECT t.item_id AS item_id
FROM 
(SELECT t.item_id AS item_id, t.score AS score, CASE WHEN t.word LIKE :like_w0 THEN 1 ELSE 0 END AS w0
FROM 
{search_api_db_actor_text} t
WHERE ( (t.word LIKE :db_condition_placeholder_6 ESCAPE '\\') )AND (field_name IN  (:db_condition_placeholder_7)) 
GROUP BY item_id, score, w0) t)) ))AND( (t_2.field_organization_type = :db_condition_placeholder_8) ))
GROUP BY item_id, score, w0, t_2.title
ORDER BY score DESC, t_2.title ASC
LIMIT 20 OFFSET 0

Notice the line:
GROUP BY item_id, score, w0) t)) ))AND( (t_2.field_organization_type = :db_condition_placeholder_6) ))

Where db_placeholder_6 should be db_placeholder_8.

Funny thing: When I put the drupal_set_message, outputting $db_query, before the line:
$results = $query->getResults();

Things work ok again. That is also the spot where I put the line:
$db_query->getArguments();

Getting confused now! :-S

Yes! The patch works! :)
Any idea when this patch is going to be in core?