Hi Saba,
Thanks for the pointer.
I did purchase the plugin and I managed to solve my issue after a few trials (there is a bug in the plugin: when you chnage the query and save it doesn't stick) I had to create a new field every time I wanted to adjust the query.
What I also did is use the debug options in Joomla and compare the queries generated with Seblod 3.3.6 in Joomla 3.3.6 and Seblod 3.8.0. in Joomla 3.5.1
Remember this is the only difference between my two sites. And in version 3.3.6 the GROUP BY t0.pk clause is present in the query.
In version 3.8.0 however it is missing.
I also use search join with a Select Dynamic (multiple) field based on tags and this is what creates the issue. When I do not make any selection if my record has multiple tags it is counted multiple times. As soon as I select values the count is alright.
Anyway to me it looks very much like a bug that you are well aware of and that should be fixed.
The search query is a workaround but it's just that. I have to update every single of my searches now and I have quite a few.
I would appreciate if you could fix the root cause of the problem.
Thanks in advance.
X.