Paste-1184206112:v:use_geshi-1:v:type-mysql

[SleePy]

SELECT m.subject, t.id_topic as topic_id, m.id_topic as mtopic_id
FROM smf_topics AS t
   INNER JOIN smf_messages AS m ON (m.id_topic = t.id_topic)
WHERE t.id_board = 6
   AND t.id_board = m.id_board
ORDER BY poster_time DESC
LIMIT 10

[SleePy]

SELECT m.subject, t.id_topic as topic_id, m.id_topic as mtopic_id
FROM smf_topics AS t
   INNER JOIN smf_messages AS m ON (m.id_topic = t.id_topic)
WHERE t.id_board = 6
   AND t.id_board = m.id_board
ORDER BY poster_time DESC
LIMIT 10


subject    topic_id    mtopic_id
Re: Ti::First Task:v:St::1:v:Co::00:v:Pr::0    63    63
Ti::Next Task:v:St::1:v:Co::10:v:Pr::0    66    66
Ti::First Task:v:St::1:v:Co::00:v:Pr::0    63    63