Hello,I am having a rather odd issue with the DataQuery api. I am using both Distinct(true) and OrderBy descending but it doesn't seem to like using them both together. If I take off the OrderBy an...
I'm trying to return the top n most read blog posts in a kentico site, but for some reason my query is returning two duplicate rows despite using the DISTINCT clause. The query is below: SELECT DIS...