mysql> SELECT question_short, (SELECT MAX(answer_id) FROM yj_questions_answers q2 WHERE q2.question_id = q1.question_id) AS answer_id, id, question_id, answer_date, answer_id FROM yj_questions_answers q1 INNER JOIN yj_questions ON id = q1.question_id GROUP BY 1 ORDER BY answer_id DESC LIMIT 10;
+---------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+------+-------------+---------------------+-----------+
| question_short                                                                                                                                                | answer_id | id   | question_id | answer_date         | answer_id |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+------+-------------+---------------------+-----------+
| DS games for learning Kanji                                                                                                                                   |      7057 | 2563 |        2563 | 2008-03-06 03:14:30 |      6910 |
| Tipping in Japan.                                                                                                                                             |      7056 | 2717 |        2717 | 2008-04-21 03:15:34 |      7053 |
| Easy Function PLAYGROUND                                                                                                                                      |      7055 | 2687 |        2687 | 2008-04-13 12:36:15 |      7017 |
| Please excuse this stupid question!                                                                                                                           |      7052 | 2706 |        2706 | 2008-04-19 01:21:12 |      7042 |
| reading hiragana                                                                                                                                              |      7051 | 2693 |        2693 | 2008-04-15 07:06:45 |      7023 |
| Using credits                                                                                                                                                 |      7050 | 2711 |        2711 | 2008-04-20 12:29:09 |      7050 |
| Is there a way to tell an active versus a passive verb?                                                                                                       |      7049 | 2704 |        2704 | 2008-04-19 01:45:47 |      7045 |
| What is the difference between TOKYO NI KURUMA GA ARU and KURUMA WA TOKYO NI IRU?                                                                             |      7046 | 2682 |        2682 | 2008-04-15 03:45:09 |      7026 |
| When <easyword id=6405 type=blue>??</easyword> or <easyword id=740 type=blue>???</easyword> is the topic do you use <easyword id=6404 type=blue>?</easyword>? |      7044 | 2702 |        2702 | 2008-04-19 01:33:46 |      7044 |
| How do you say WHO is in the park?                                                                                                                            |      7037 | 2689 |        2689 | 2008-04-15 04:00:46 |      7028 |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+------+-------------+---------------------+-----------+
10 rows in set (0.46 sec)