proper one, i think

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