Enable Hibernate SQL logging to diagnose members query returning 0

Temporarily enabled org.hibernate.SQL=DEBUG to see what SQL the TYPE() JPQL query generates for the members-subscribers endpoint.

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.