AV8SSForum
September 25, 2018, 07:36:54 am
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Welcome to the official AV8SS Forum. All racers, automotive junkies, sponsors, speed-freaks, and huckleberries welcome. Please become a member and post today! www.av8ss.com
 
   Home   Help Search Staff List Calendar Login Register  

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.


SELECT
c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.description,
b.numPosts, b.numTopics, b.ID_PARENT, IFNULL(m.posterTime, 0) AS posterTime,
IFNULL(mem.memberName, m.posterName) AS posterName, m.subject, m.ID_TOPIC,
IFNULL(mem.realName, m.posterName) AS realName,
1 AS isRead, 0 AS new_from,
IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, m.ID_MSG,
IFNULL(mods_mem.ID_MEMBER, 0) AS ID_MODERATOR, mods_mem.realName AS modRealName
FROM av8ss_boards AS b
LEFT JOIN av8ss_categories AS c ON (c.ID_CAT = b.ID_CAT)
LEFT JOIN av8ss_messages AS m ON (m.ID_MSG = b.ID_LAST_MSG)
LEFT JOIN av8ss_members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN av8ss_moderators AS mods ON (mods.ID_BOARD = b.ID_BOARD)
LEFT JOIN av8ss_members AS mods_mem ON (mods_mem.ID_MEMBER = mods.ID_MEMBER)
WHERE FIND_IN_SET(-1, b.memberGroups)
AND b.childLevel <= 1 ORDER BY b.boardOrder
Back
Bookmark this site! | Upgrade This Forum
SMF For Free - Create your own Forum

Buy traffic for your forum/website
traffic-masters
Powered by SMF | SMF © 2016, Simple Machines
Privacy Policy