Lapidary / Gemstone Community Forum
June 19, 2019, 01:42:02 am
Welcome, Guest. Please login or register.

Login with username, password and session length
 
   Home   Help Search Login Register  
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.


SELECT
b.ID_BOARD, b.name, b.description, b.numTopics, b.numPosts,
m.posterName, m.posterTime, m.subject, m.ID_MSG, m.ID_TOPIC,
IFNULL(mem.realName, m.posterName) AS realName, 1 AS isRead,
IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, IFNULL(mem2.ID_MEMBER, 0) AS ID_MODERATOR,
mem2.realName AS modRealName
FROM gemstone_boards AS b
LEFT JOIN gemstone_messages AS m ON (m.ID_MSG = b.ID_LAST_MSG)
LEFT JOIN gemstone_members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN gemstone_moderators AS mods ON (mods.ID_BOARD = b.ID_BOARD)
LEFT JOIN gemstone_members AS mem2 ON (mem2.ID_MEMBER = mods.ID_MEMBER)
WHERE b.ID_PARENT = 45
AND FIND_IN_SET(-1, b.memberGroups)
Bookmark this site! | Upgrade This Forum
SMF For Free - Create your own Forum | Buy traffic for your forum/website

Powered by SMF | SMF © 2016, Simple Machines
Privacy Policy