SELECT
c.*,
t.topic_title as topic_title,
t.topic_count_comment as topic_count_comment,
u.user_profile_avatar as user_profile_avatar,
u.user_profile_avatar_type as user_profile_avatar_type,
u.user_login as user_login,
b.blog_title as blog_title,
b.blog_type as blog_type,
b.blog_url as blog_url,
u_owner.user_login as blog_owner_login
FROM
prefix_topic_comment_online as co
JOIN prefix_topic_comment AS c ON co.comment_id=c.comment_id
JOIN prefix_topic AS t ON co.topic_id=t.topic_id
JOIN prefix_user AS u ON c.user_id=u.user_id
JOIN prefix_blog AS b ON t.blog_id=b.blog_id
JOIN prefix_user AS u_owner ON b.user_owner_id=u_owner.user_id
ORDER by co.comment_online_id desc limit N, N

SELECT
t_fast.*,
tc.*,
u.user_login as user_login,
IF(tv.topic_id IS NULL,N,N) as user_is_vote,
tv.vote_delta as user_vote_delta,
IF(tqv.topic_id IS NULL,N,N) as user_question_is_vote,
bu.is_moderator as user_is_blog_moderator,
bu.is_administrator as user_is_blog_administrator,
IF(tr.comment_count_last IS NULL,t_fast.topic_count_comment,t_fast.topic_count_comment-tr.comment_count_last) as count_comment_new,
IF(ft.topic_id IS NULL,N,N) as topic_is_favourite
FROM (
SELECT
t.*,
b.blog_title as blog_title,
b.blog_type as blog_type,
b.blog_url as blog_url,
b.user_owner_id as blog_owner_id
FROM
prefix_topic as t,
prefix_blog as b
WHERE
N=N
AND t.topic_publish = N AND ( t.topic_rating >= N or topic_publish_index=N ) AND b.blog_type in ('S','S')
AND
t.blog_id=b.blog_id
ORDER by t.topic_date_add desc
LIMIT N, N
) as t_fast
JOIN prefix_user AS u ON t_fast.user_id=u.user_id
LEFT JOIN (
SELECT
topic_id,
vote_delta
FROM prefix_topic_vote
WHERE user_voter_id = -N
) AS tv ON t_fast.topic_id=tv.topic_id
LEFT JOIN (
SELECT
topic_id
FROM prefix_favourite_topic
WHERE user_id = -N
) AS ft ON t_fast.topic_id=ft.topic_id
LEFT JOIN (
SELECT
topic_id,
comment_count_last
FROM prefix_topic_read
WHERE user_id = -N
) AS tr ON t_fast.topic_id=tr.topic_id
LEFT JOIN (
SELECT
topic_id
FROM prefix_topic_question_vote
WHERE user_voter_id = -N
) AS tqv ON t_fast.topic_id=tqv.topic_id
LEFT JOIN (
SELECT
is_moderator,
is_administrator,
blog_id
FROM prefix_blog_user
WHERE user_id = -N
) AS bu ON t_fast.blog_id=bu.blog_id
JOIN prefix_topic_content AS tc ON t_fast.topic_id=tc.topic_id
order by t_fast.topic_date_add desc