In aggregated query without GROUP BY expression #1 of SELECT list contains nonaggregated column ashopTaskId; this is incompatible with sql_mode=only_full_group_by

The error message you are seeing is related to the SQL mode only_full_group_by. This mode enforces that all columns in the SELECT list must either be part of the GROUP BY clause or be used with an aggregate function like SUM, COUNT, etc.

In your case, you are using an aggregated query without a GROUP BY clause, and the column a.shopTaskId is not being aggregated or included in the GROUP BY clause. To resolve this error, you have a few options:

Include the non-aggregated column in the GROUP BY clause:

SELECT a.shopTaskId, MAX(a.someColumn)
FROM yourTable a
GROUP BY a.shopTaskId;

Use an aggregate function on the non-aggregated column:

SELECT MAX(a.shopTaskId), MAX(a.someColumn)
FROM yourTable a;

Disable the only_full_group_by mode by running the following statement before executing your query:

SET sql_mode = '';

Note that disabling the only_full_group_by mode may have other implications, so use it with caution.

Choose the option that best suits your requirements and adjust your query accordingly