Massimiliano Arione

Let me be more clear (sorry but yesterday I replied from my mobile): you should use [isXmlHttpRequest method](https://github.com/symfony/symfony/blob/474fc8112bf0e4bc0fc3353b30b3c36361e3d8b1/src/Symfony/Component/HttpFoundation/Request.php#L1649) instead of relying on a query parameter.

> I am using fetch for my ajax calls and if I am not wrong, it does not send the needed information for isXMLHttpRequest. You just need to use the...

What is the resulting query?

I try again: what is the query that gives error?

That's not a query. A query is something you can put inside postgresql

https://www.postgresql.org/docs/current/queries-overview.html

Is the query working if you run it directly in postgres?

Can you provide the difference between the raw query and the query resulting from applying the paginator?

That's not the right query, since (based on your error), it must contain a DISTINCT. Can't you just get the query from Symfony profiler?

Can you try using [manual counting](https://github.com/KnpLabs/KnpPaginatorBundle/blob/master/docs/manual_counting.md)?