SleePyCode Forums

Special Site & Other Boards => PasteBin => Topic started by: SleePy on Jul 12, 2007, 02:08 AM

Title: Paste-1184206112:v:use_geshi-1:v:type-mysql
Post by: SleePy on Jul 12, 2007, 02:08 AM
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
Title: Paste-1184206134:v:use_geshi-1:v:type-mysql
Post by: SleePy on Jul 12, 2007, 02:08 AM
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