mysql> select * from wanyouxi where youxitag='bird' ORDER BY credits desc limit 1;
+-------+------+--------+------------+---------+------------+------+-----+------+
| id | uid | gameid | youxitag| credits | dateline | type | sid | wins |
+-------+------+--------+------------+---------+------------+------+-----+------+
| 49578 | 1155 | 0 | bird| 43830 | 1221623720 | 0 | 6 | 0 |
+-------+------+--------+------------+---------+------------+------+-----+------+
1 row in set (0.37 sec)
mysql> SELECT * from wanyouxi where youxijifen= (SELECT MAX(youxijifen) FROM cdb_playsgame where youxitag='bird') and youxitag='bird';
+-------+------+--------+------------+---------+------------+------+-----+------+
| id | uid | gameid | youxitag| credits | dateline | type | sid | wins |
+-------+------+--------+------------+---------+------------+------+-----+------+
| 49578 | 1155 | 0 | bird| 43830 | 1221623720 | 0 | 6 | 0 |
+-------+------+--------+------------+---------+------------+------+-----+------+
1 row in set (0.30 sec)