SELECT t.topic_first_post_id,t.topic_title, p.post_text, t.topic_time, i.info_name, t.forum_id, p.bbcode_bitfield, p.bbcode_uid, u.username, u.user_id, u.user_icq,u.user_aim,i.info_id,i.info_asm, t.topic_views, t.topic_replies  FROM phpbb_topics t LEFT JOIN phpbb_infos i on t.topic_class = i.info_id, phpbb_posts p, phpbb_users u where t.topic_id = 39964 AND p.topic_id = t.topic_id AND u.user_id = t.topic_poster AND t.topic_first_post_id = p.post_id