alias multisite

I'm trying to get a list of user emails that belong to the role 'site administrators' from a remote multisite Drupal environment. When I run the following command:

drush @remote_site sql-query 'SELECT DISTINCT u.mail FROM users AS u LEFT JOIN users_roles AS ur ON u.uid=ur.uid LEFT JOIN role AS r ON ur.rid=r.rid WHERE r.name = "site administrator"'

I'm trying to get a list of user emails that belong to the role 'site administrators' from a remote multisite Drupal environment. When I run the following command:

drush @remote_site sql-query 'SELECT DISTINCT u.mail FROM users AS u LEFT JOIN users_roles AS ur ON u.uid=ur.uid LEFT JOIN role AS r ON ur.rid=r.rid WHERE r.name = "site administrator"'

I've searched and searched and searched drupal.org multi-site documentation, forums, issues etc along with the web and can't find answer to my conundrum on subpath (URL path) site installs with symlinks. Sub-domains are not an issue.

Hi,

first time I'm posting but I've a small problem.

I'm running multisites which are sharing nodes, content_types, users and roles. I'm doing it just by sharing the tables on the same database.

I'm using Autopath with the same config on each site to enable some "smart" aliases for each content type.

I've a "static" content which is a content that is supposed to be used for static pages with one alias and that won't be dynamically used as a blog post or a news or an event.