1. ggaillet
  2. Support
  3. Tuesday, May 04 2021, 08:52 PM
  4.  Subscribe via email

Need help again on the SQL WHERE filter.
I want to display in the table users that are simultaneously part of group_id IN (26) AND group_id IN (28).
This synthax doesn't appear to work though. What synthax should I use then?
admin Accepted Answer
you can find an example at (see at "User From 2 Groups at the same time";)
  1. 5 days ago
  2. Support
  3. # 1
ggaillet Accepted Answer
Ah OK, missed that one. Thanks. Wow, I would have NEVER found the syntax myself! :o :(
  1. 4 days ago
  2. Support
  3. # 2
  • Page :
  • 1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.


Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy ProfileĀ® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.