Anonymous

SELECT  b.boardname,  b.boardid,  t.threadname,  t.threadid,  t.locked,  t.sticky,  ti.ticonpath,  p.postid   FROM boards b,        threads t,        thread_icons ti,        posts p,        users u    WHERE t.threadid = p.threadid    AND t.boardid = b.boardid    AND t.ticonid = ti.ticonid    AND p.threadid = t.threadid    AND p.threadstarter     ORDER BY b.boardname