SELECT bid.id, bid.auction_id, bid.user_id, bid.created
FROM auction JOIN bid
ON bid.auction_id = auction.id
WHERE bid.user_id =25 GROUP BY auction.id ORDER BY bid.created;
+--------+------------+---------+---------------------+
| id | auction_id | user_id | created |
+--------+------------+---------+---------------------+
| 226458 | 2012 | 25 | 2011-05-02 08:01:32 |
| 226465 | 2016 | 25 | 2011-05-03 06:39:44 |
+--------+------------+---------+---------------------+