Niels Lucas

2.4.0 DISTINCT FirstOrDefault without Order By defined adds wrong Order BY statement - SqlServerCompiler

2

Query: ``` var query = Db.Query("tdProducts") .Select("tdProductTypes.IsStock", "tdProductVariants.MainVariantID") .Distinct() .Join("tdProductTypes", "tdProductTypes.ProductTypeID", "tdProducts.ProductType") .Join("tdProductVariants", "tdProductVariants.ProductID", "tdProducts.ProductID") .Join("tdDimensionCombinations", "tdDimensionCombinations.VariantID", "tdProductVariants.VariantID") .Join("tdDimensions", j => j.On("tdDimensions.DimensionID", "tdDimensionCombinations.DimensionID") .WhereIfNotNull("tdDimensions.scnlDimensionUnit", 0)) .Join("tdDimensionValues", j => j.On("tdDimensionValues.DimensionID", "tdDimensions.DimensionID")...