SQL command to hide duplicated members

Hi,

I'm encountering an issue with our members list where members with multiple plans are appearing multiple times. My objective is to display each member only once, regardless of how many plans they are subscribed to.

To address this, I attempted the following SQL query at the menu-item: Members list... on the tab: "Members data SQL Filter"

However, I encountered a syntax error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT user_id FROM msw73_osmembership_subscribers; AND tbl.show_on_mem' at line 5

Could you provide some guidance on how to resolve this issue?

Kind regards,
Lumiga
 

Hi Lumiga

Unfortunately, I could not see a way to handle this via SQL. For each plan users subscribed for, there will be one record displayed and it could not be changed

Tuan

I'd like to chime in on this.

I am experiencing a similar issue that may be related.

I have a menu item that displays a Membership Pro Member List for subscribers of all plans; under that menu item's "Options" tab, I have "Subscription Status" set to "Active".

Despite "Subscription Status" being set to "Active", I still see expired members on the Member List.

Maybe this is the issue that the OP is having? Can you take a look at this, Tuan?

Thanks!
Elliot

Hi Elliot

Could you please submit a support ticket so that I can check the issue directly on your site? I would need to have super user account of the site, link to the page and tell me sample expired Member who should not be displayed but still being displayed so that I can check it

Tuan

Just submitted the ticket.

Thank you!

Thanks Elliot. Will check and reply you via support ticket

Regards,

Tuan