What is ORDER BY Clause? The ORDER BY clause is used to sort the MySQL table data in an ascending or descending order. The ORDER BY Clause can be used along with the SELECT statement to sort the data ...
After running the query you then apply filter in results window in dbeaver on city column, you get the following error: SQL Error [1033] [S0001]: The ORDER BY clause ...
The tables "item" and "item_img" have the same column "created_time", and the "order by" clause doesn't add table alias as the column's prefix, so it crashed.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback