• OctoberCMS Build: 466
• PHP Version: 7.2^
• Database Engine: MySQL MariaDB 10.3.23 (with strict set to true through database.php configuration)

Description:

For one of our plugins we're currently running into the error described below:

SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

The query in question:

SELECT   `model_a`.*, 
         ( 
                  SELECT   count(*) 
                  FROM     `model_b` 
                  WHERE    `model_a`.`id` = `model_b`.`model_a_id`
                  ORDER BY `sort_order` ASC) AS `model_b_count`, 
         `model_a`.* 
FROM     `model_a` 
ORDER BY `NAME` DESC limit 20 offset 0;

The issue is the result of a combination using count on a model with the sortable trait (which will add sorting through a global scope) and the mysql strict setting being true.

I've traced the issue back to the withCount method in src/Illuminate/Database/Eloquent/Concerns/QueriesRelationships.php. So it's an issue in Laravel.
Digging further I've noticed that this issue has actually been resolved in 7.x with this pull request: https://github.com/laravel/framework/pull/29925/files
In 6.x however this has not been fixed.

Additionally: withCount seems to add a model.* to the query, the list widget adds another model.* to the select at the end of the method. It's a bit weird but this does not cause any issues.

Steps To Reproduce:

Apply 'strict' => true, to the mysql database configuration through database.php.

Create a plugin with 2 models and a controller with list view.
Model 1 has many Model 2.
Model 2 has sortable trait.
Model 1 columns shows count of model 2 relations.
Visit the list view page and see an error.