List with users, that are subscribed to an acymailing list

Hi there,
I need to set up a list of my users, that are subscribed to my newsletter. As newsletter component I use acymailing. Is this possible?

Yes, you can use Advanced filters in your userlist to directly add to the query to filter it as needed, but you'll need to write the SQL for that.

Thank you Kyle,
I think I don't understand, how the advanced filter works.
I have a query that returns 1 (my list id) if the email address is subscribed to the list and it returns an empty set, if the email address is not subcribed to the list. This query works fine, if I run it in PHPMyAdmin, (substuting \[email\] with real email addresses) but my list is empty despite the fact, that there are multiple users subscribed to this list.

The advanced filter directly adds to the WHERE statement of the userlist query. Example as follows.

That would filter on the cb_myfield field of the _comprofiler table checking for the value 123. This is added to the query as an AND. The table alias "ue" refers to _comprofiler and "u" to _users (this is noted in the parameter description with examples as well).

You won't be able to do any joins here so you need to write your query as a subquery to filter the list down. I'm not familiar with AcyMailing data structure, but below is an example based off what I could find about the structure of acym_user_has_list table.

I'm afraid, this won't work, because for some reason acym_user_has_list.user_id is not equal to u.id. There is another table acym_user that translates joomla user ids to acymailing user ids, that's why I used the join.
Can I use joins with the query field? Maybe I could use the query field and use it's result for my filter?

You can use a join in the select subquery and that should solve your issue.

Can I use joins with the query field? Maybe I could use the query field and use it's result for my filter?

No, query fields have no storage and they can't be used to insert queries into other queries.