I want to paginate my data like this
SELECT COUNT(DISTINCT id) as total FROM table ....
paginate method always generates this query
SELECT COUNT(*) as total FROM table ....
How can I change paginate query. is it possible to extend
QueryBuilder to achieve this using
any help. Thanks