Внутри ORDER BY нужно поставить это: ORDER BY ABS(`forecast`- 1.16684)
Запрос sql:
Код: Выделить всё
SELECT c.*, u.user_email FROM competition c LEFT JOIN users u ON c.user_id = u.user_id WHERE c.pair = 'EUR/USD' ORDER BY ABS(`forecast`- 1.16684)
Код: Выделить всё
$winners = Competition::find()
->leftJoin($customerTable, "$competitionTable.user_id = $customerTable.user_id")
->where(["pair" => $pair])
->orderBy("forecast - 1.16684")
->all();
Column not found: 1054 Unknown column 'forecast - 1.16684' in 'order clause''