LPS-40102 Removing distinct (do not merge)

It is inefficient and usually unsuported to perform distinct on longtext
columns

Please check whether this distinct is truly necessary
LPS-40102 DISTINCT is not needed, and fix DISTINCT for COUNT