rendered paste body SELECT
tmk3_trade.widet,
tmk3_trade.context,
tmk3_trade.price,
tmk3_trade.time,
MAX(tmk3_trade.time)
FROM
tmk3_trade
WHERE
tmk3_trade.station = 15221
GROUP BY
tmk3_trade_widget
ORDER BY
tmk3_trade.context,
tmk3_trade.price
;
+---------+---------------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| widget | int(11) | NO | | 0 | |
| station | int(11) | NO | | 0 | |
| context | enum('buy','sell','want') | NO | | buy | |
| user | int(11) | NO | | 0 | |
| time | timestamp | NO | | CURRENT_TIMESTAMP | |
| price | int(11) | NO | | 0 | |
+---------+---------------------------+------+-----+-------------------+----------------+