m.*, COALESCE(m.flag_cc, u.flag_cc) AS disp_flag_cc, COALESCE(m.flag_country, u.flag_country) AS disp_flag_country,
t.thread_opt, t.root_msg_id, t.last_post_id, t.forum_id,
u.id AS user_id, u.alias AS login, u.avatar_loc, u.email, u.posted_msg_count, u.join_date, u.location,
u.sig, u.custom_status, u.icq, u.jabber, u.aim, u.msnm, u.yahoo, u.google, u.skype, u.twitter, u.users_opt, u.last_visit AS time_sec, u.karma,
l.name AS level_name, l.level_opt, l.img AS level_img,
p.max_votes, p.expiry_date, p.creation_date, p.name AS poll_name, p.total_votes,
karma.id AS cant_karma,
1 AS cant_vote
FROM fud30_msg m
INNER JOIN fud30_thread t ON m.thread_id=t.id
INNER JOIN fud30_forum f ON t.forum_id=f.id
LEFT JOIN fud30_users u ON m.poster_id=u.id
LEFT JOIN fud30_level l ON u.level_id=l.id
LEFT JOIN fud30_karma_rate_track karma ON karma.msg_id=m.id AND karma.user_id=0
LEFT JOIN fud30_poll p ON m.poll_id=p.id WHERE m.thread_id=176165 AND m.apr=1 ORDER BY m.id ASC LIMIT 40 OFFSET 0
Baen's Bar: Welcome to the Bar » Welcome to the Bar
maor Messages: 13841 Registered: January 2012 Location: Israel
The Bar is no longer open to the public, but a privilege granted only to those who have made a purchase from Baen.com and who choose to exercise that privilege. Previous users active in the last 12 months have been grandfathered in. We have added a tipjar, so that you do not even need to buy a book, merely contribute something to the maintenance of the Bar.
The tipjar is located at baen.com, which makes sense both because it needs to be available to people who are not yet registered participants here, and also because that's the site that is in the business of selling, handling money. Type in tipjar (one word) in the search function at the top of the page, and up it pops.
Be sure to use the same email account to make your tip/purchase as the one you want to have credited with it on the Bar.