Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.
The SQL being executed was: SELECT [const_service_charge].*, [const_lab].[name] AS [labname] FROM [const_service_charge] LEFT JOIN [const_lab] ON [const_service_charge].[lab] = [const_lab].[lab] WHERE ([const_service_charge].[lab] != 'patho_ot') AND ([const_service_charge].[name] != '88888') AND (const_service_charge.lab not in ('autopsy') ) AND (price != 0 and status_id = 1) ORDER BY [const_service_charge].[lab], [const_service_charge].[name], [lab]

Error Info: Array
(
    [0] => 42000
    [1] => 169
    [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.
    [3] => 42000
    [4] => 8180
    [5] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.
)
$_GET = [
    'page' => '10',
    'sort' => 'lab',
];