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)