Hi,
I do use the "search query" plugin to add "GROUP BY t0.pk" to fix the pagination issue that I had.
I
tried to add an ORDER BY clause after the GROUP BY, unfortunately, the
system adds its own "ORDER BY created" after mine and I get an SQL error
because the generated statement has two "ORDER BY" clauses one after
the other.
For the record I also use the "search join" plugin in my search. I don't know if it has an influence on the issue.
Thanks for your help.
Xav.
NB:
I keep having errors when I try to submit posts on this forum. I end up
having to resubmit because my posts are not attached to the original
topic and the topic is the timestamp when it was submitted. e.g. this one and that one.
It seems to work when I reply to the last post, not when I reply to the topic FYI.