MySQL Error 3065 – ER_FIELD_IN_ORDER_NOT_SELECT

MySQL Error Message

Expression #%u of ORDER BY clause is not in SELECT list,
references column ‘%s’ which is not in SELECT list; this is
incompatible with %s