Incubator » CB Gallery

There's no efficient way of doing this. Currently the item count is a simple and fast subquery. To remove empty rows the tables must be joined. Joining the tables will results in a significant performance hit. For the usecase in the attached forum topic they realistically should be using different gallery assets. So for example if they want a gallery with photos only they can use profile.[user_id].photos and set it to only allow photos. If you want all these sub galleries displayed in a single gallery you'd use profile.[user_id]% wildcard usage.