mysql> SELECT question_short, (SELECT MAX(answer_date) 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                                                                                                                                   | 2008-04-21 06:53:59 | 2563 |        2563 | 2008-03-06 03:14:30 |      6910 |
| Tipping in Japan.                                                                                                                                             | 2008-04-21 06:20:43 | 2717 |        2717 | 2008-04-21 03:15:34 |      7053 |
| Easy Function PLAYGROUND                                                                                                                                      | 2008-04-21 06:13:19 | 2687 |        2687 | 2008-04-13 12:36:15 |      7017 |
| Using credits                                                                                                                                                 | 2008-04-20 12:29:09 | 2711 |        2711 | 2008-04-20 12:29:09 |      7050 |
| Is there a way to tell an active versus a passive verb?                                                                                                       | 2008-04-20 12:16:45 | 2704 |        2704 | 2008-04-19 01:45:47 |      7045 |
| Please excuse this stupid question!                                                                                                                           | 2008-04-20 08:45:14 | 2706 |        2706 | 2008-04-19 01:21:12 |      7042 |
| reading hiragana                                                                                                                                              | 2008-04-20 03:00:22 | 2693 |        2693 | 2008-04-15 07:06:45 |      7023 |
| What is the difference between TOKYO NI KURUMA GA ARU and KURUMA WA TOKYO NI IRU?                                                                             | 2008-04-19 01:48:30 | 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>? | 2008-04-19 01:33:46 | 2702 |        2702 | 2008-04-19 01:33:46 |      7044 |
| How do you say WHO is in the park?                                                                                                                            | 2008-04-17 09:19:46 | 2689 |        2689 | 2008-04-15 04:00:46 |      7028 |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+------+-------------+---------------------+-----------+
10 rows in set (0.48 sec)