Обычный
Как-то так:[CODE]SELECT t.topic_id, p.post_id, p.post_htmlFROM bb_topics t, bb_posts_html pLEFT JOIN bb_bt_torrents tor ON (tor.post_id = p.post_id)WHERE t.topic_first_post_id = p.post_idAND tor.topic_id IS NOT NULLLIMIT 0, 10[/CODE]
Как-то так:
[CODE]SELECT t.topic_id, p.post_id, p.post_html
FROM bb_topics t, bb_posts_html p
LEFT JOIN bb_bt_torrents tor ON (tor.post_id = p.post_id)
WHERE t.topic_first_post_id = p.post_id
AND tor.topic_id IS NOT NULL
LIMIT 0, 10[/CODE]
