Multiple same hits on searches on themes

[ipajen]

https://sandbox.aspirepress.org/themes/?keyword=Denim

Get 4 hits of same theme, expecting 1 .

[chuckadams]

It's a known bug due to the way search currently works: it does a UNION of multiple queries, and for performance reasons it does not use DISTINCT over them. I don't see a lot of good solutions to this, so I may just have to bite the bullet and add the DISTINCT clause; ultimately we're going to have to move search off of a SQL database and onto something zippier like ElasticSearch.