It appears this has something to do with the DISTINCT clause, as it works as expected with the DISTINCT clause removed, but continues to return incorrect data when the DICTINCT...