Hi guys,

I can't get the following query to work..

Our platform has relevant usergroups "concept" and "published", (2 and 12)

We got an EP field "category" (SELECT LIST)
We got an EP field "platform" (SELECT LIST)

One of our landingpages should show users that
- are in user group "published"
- have selected in "platform" at least a certain option enabled
- have selected in "category" at least a certain option enabled

So one user meets these requirements but he the profile does not show up

I tried these:

b.`categorie` LIKE '%\"6\"%' AND b.'platform' LIKE '%\"1\"%' AND group_id IN 12

b.`categorie` LIKE '%\"6\"%' AND b.'platform' LIKE '%\"1\"%' AND group_id=12

b.`categorie` LIKE '%\"6\"%' AND 'platform' LIKE '%\"1\"%' AND group_id IN 12

b.`categorie` LIKE '%\"6\"%' AND 'platform' LIKE '%\"1\"%' AND group_id=12

Can you please help me out?

greetz,

Dennis