SELECT
                                        m.*,
                                        u.alias,
                                        t.forum_id,
                                        p.name AS poll_name, p.total_votes,
                                        m2.subject AS th_subject,
                                        m3.subject AS reply_subject,
                                        f.name AS frm_name,
                                        c.name AS cat_name
                                FROM
                                        fud_msg m
                                        INNER JOIN fud_thread t ON m.thread_id=t.id
                                        INNER JOIN fud_forum f ON t.forum_id=f.id
                                        INNER JOIN fud_cat c ON c.id=f.cat_id
                                        INNER JOIN fud_msg m2 ON t.root_msg_id=m2.id
                                        LEFT JOIN fud_msg m3 ON m3.id=m.reply_to
                                        LEFT JOIN fud_users u ON m.poster_id=u.id
                                        LEFT JOIN fud_poll p ON m.poll_id=p.id

                                WHERE
                                         t.moved_to=0 AND m.apr=1 ORDER BY m.post_stamp ASC LIMIT 0,100;