this request is working fine.
<code>SELECT max(original_id) from search_results
</code>
<code>SELECT max(original_id) from search_results
</code>
SELECT max(original_id) from search_results
but I need
<code>SELECT max(original_id),created from search_results
</code>
<code>SELECT max(original_id),created from search_results
</code>
SELECT max(original_id),created from search_results
and I get an error
<code>Error Code: 1140. In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'sys.search_results.created'; this is incompatible with sql_mode=only_full_group_by 0.047 sec
</code>
<code>Error Code: 1140. In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'sys.search_results.created'; this is incompatible with sql_mode=only_full_group_by 0.047 sec
</code>
Error Code: 1140. In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'sys.search_results.created'; this is incompatible with sql_mode=only_full_group_by 0.047 sec
I do not have database administrator rights and I do not have access to switch “only_full_group_by” mode. How can I fix my request?