Save the Train
Welcome, Guest. Please login or register.
October 21, 2020, 11:00:56 am

Login with username, password and session length
Search:     Advanced search
Recommended service - hourly, according to the GWRUS. Let's work towards that service and towards ensuring all services are used.
7748 Posts in 4932 Topics by 29319 Members
Latest Member: IngvarGar
* Home Help Search Calendar Login Register
Database Error
SELECT t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL, IFNULL(lt.logTime, IFNULL(lmr.logTime, 0)) AS isRead, t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.modifiedTime AS lastModifiedTime, ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName, ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName, t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime, mf.modifiedTime AS firstModifiedTime, mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName, mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName, LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys, mf.smileysEnabled AS firstSmileys FROM smf_topics AS t, smf_messages AS ml, smf_messages AS mf LEFT JOIN smf_members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER) LEFT JOIN smf_members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER) LEFT JOIN smf_log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = 0) LEFT JOIN smf_log_mark_read AS lmr ON (lmr.ID_BOARD = 8 AND lmr.ID_MEMBER = 0) WHERE t.ID_BOARD = 8 AND ml.ID_MSG = t.ID_LAST_MSG AND mf.ID_MSG = t.ID_FIRST_MSG ORDER BY t.isSticky DESC, t.ID_LAST_MSG DESC LIMIT 0, 20
Back
Powered by MySQL Powered by PHP Save the Train | Powered by SMF 1.0.5.
© 2001-2005, Lewis Media. All Rights Reserved.
Valid XHTML 1.0! Valid CSS!
Page created in 0.179 seconds with 13 queries.