View filter not working with Domain module

Seems probably to be Domain module specific

I'm not sure if this is the same situation but Faceted Search only works with Domain Access module if I'm loged in as the administrator user.

Otherwise I observed that MySQL practically hangs, consumes huge amount of memory and blocks almost all subsequent queries if I'm not loged as admin. The query that hangs MySQL is like this:

SELECT DISTINCT COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS tid, term_data.name AS name
    FROM drupal_node AS n
    INNER JOIN temp_faceted_search_results_5 AS results ON
        solhub.drupal_domainn.nid = results.nid
        INNER JOIN drupal_term_node AS term_node ON
            n.vid = term_node.vid
           INNER JOIN drupal_term_data AS term_data ON
            term_node.tid = term_data.tid
            INNER JOIN drupal_node_access na ON
            na.nid = n.nid
                WHERE (na.grant_view >= 1 AND (
                    (na.gid = 0 AND na.realm = 'all') OR
                    (na.gid = 0 AND na.realm = 'domain_site') OR
                    (na.gid = 2 AND na.realm = 'domain_id')))
                AND (((SELECT COUNT(1) FROM drupal_node_access nasq WHERE na.nid=nasq.nid AND gid=0 AND realm='all') > 0) OR
                ((SELECT COUNT(1) FROM drupal_node_access nasq WHERE na.nid=nasq.nid AND realm IN ('domain_site','domain_id')) = 0 OR
                    (SELECT COUNT(1) FROM drupal_node_access nasq WHERE na.nid=nasq.nid AND ((gid=0 AND realm='domain_site') OR
                        (gid=2 AND realm='domain_id'))) > 0)) AND
                        (  ((term_data.vid = 11) AND (n.type IN ('offering'))) )

Apparently these nested JOINs are the problem.

I also tryied the domain_adv module but then the effect is to not show any node.

Normal Views that don't use Faceted Search work both with ot without domain_adv.

Correction: Faceted Search actually works with Domain Access but the above query takes a lot of time and CPU power. In a multiple users environment (many users navigating at the same time) the DB server gets exausted and it feels like the browser will never get a response from the server.

Any help ?

After further investigation, I don't think my Domain Access module-related problem on #2 is related to this original issue so I created a new support request: #1115458: Impossible to run Faceted Search with Domain module

I am closing this issue, as Drupal 6 is now not supported.