First message field in database

[xantos]

I want choose first field message in topic from database only.
When I checked out messages table - there were all messages.
How can I know which topic's message is the first   ?

[Oya]

if you look at the smf_topics table there is a column called id_first_msg

query the smf_topics table joining smf_messages on smf_topics.id_first_msg = smf_messages.id_msg it will work