gistfile1.php

$transes = (new \yii\db\Query())
->select('DATE_FORMAT(FROM_UNIXTIME(`created`), "%M %Y") as `dates`, SUM(amount) AS amount, SUM(fee) AS fee, SUM(net) AS net, SUM(IF(`amount`< 0, `amount`, 0 )) AS pay_out')
->from('tbl_transaction_newest')
->groupBy('`dates`')
->limit(1000)
->orderBy('created')
->all();

gistfile2.txt

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `pay_out` FROM `tbl_transaction_newest` GROUP BY `dates` ORDER BY `created` L' at line 1
The SQL being executed was: SELECT DATE_FORMAT(FROM_UNIXTIME(`created`), "%M %Y") as `dates`, SUM(amount) AS amount, SUM(fee) AS fee, SUM(net) AS net, SUM(IF(`amount`< `0`, `amount`, `0 ))` AS `pay_out` FROM `tbl_transaction_newest` GROUP BY `dates` ORDER BY `created` LIMIT 1000
Error Info: Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `pay_out` FROM `tbl_transaction_newest` GROUP BY `dates` ORDER BY `created` L' at line 1