Кому интересно есть такая штука dbForge studio for Mysql (бесплатная)
Там есть дизайнер sql запросов с графическим интерфейсом drag n drop. Для нубов в mysql самое то
[SPOILER="img"]
[/SPOILER]
[SPOILER="Вот такой запрос у меня получился"][CODE]SELECT
k.post_id,
k.mode,
k.time,
u.username,
u.user_id,
p.post_karma,
u.user_rank,
u2.username AS k_username,
u2.user_id AS k_user_id,
u2.user_rank AS k_user_rank,
IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text,
t.topic_title,
tor.topic_id AS is_release,
bb_attachments_desc.rating_sum,
bb_attachments_desc.rating_count,
bb_attachments_desc.thanks
FROM bb_karma k
LEFT JOIN bb_users u
ON u.user_id = k.poster_id
LEFT JOIN bb_users u2
ON u2.user_id = k.user_id
LEFT JOIN bb_posts p
ON p.post_id = k.post_id
LEFT JOIN bb_topics t
ON p.topic_id = t.topic_id
LEFT JOIN bb_posts_text pt
ON pt.post_id = k.post_id
LEFT JOIN bb_posts_html h
ON h.post_id = k.post_id
LEFT OUTER JOIN bb_bt_torrents tor
ON tor.topic_id = t.topic_id
LEFT JOIN bb_attachments_desc
ON tor.attach_id = bb_attachments_desc.attach_id
WHERE k.poster_id = $user_id
ORDER BY k.time DESC
LIMIT $start, $per_page
");[/CODE][/SPOILER]
