Witam.

Przesyłam zapytania, które powodują problem:

# User@Host: motomania[motomania] @ [85.128.186.62]
# # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
# use motomania;
# SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies,
# t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id,
# t.topic_poster, f.forum_name, f.forum_status, f.forum_id,
# f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit,
# f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate,
# f.auth_vote, f.auth_attachments, f.attached_forum_id
# FROM phpbb_topics t, phpbb_forums f
# WHERE t.topic_id = 3374
# AND f.forum_id = t.forum_id;
#


# Time: 080608 7:11:53
# # User@Host: motomania[motomania] @ [85.128.186.62]
# # Query_time: 2 Lock_time: 0 Rows_sent: 15 Rows_examined: 1731
# use motomania;
# SELECT u.username, u.user_id, u.user_posts, u.user_from,
# u.user_pojazd, u.user_website, u.user_email, u.user_icq, u.user_aim,
# u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,
# u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar,
# u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,
# u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id ,
# p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude,
# m.latitude
# FROM phpbb_posts p, (phpbb_users u LEFT JOIN
# phpbb_map_mod_user m ON u.user_id=m.user_id LEFT JOIN
# phpbb_banlist b ON u.user_id=b.ban_userid), phpbb_posts_text
# pt
# WHERE p.topic_id = 5720
#
# AND pt.post_id = p.post_id
# AND u.user_id =
# p.poster_id
# AND
#
p.post_flagged
# <> 1
#
ORDER
# BY
#
p.post_time
#
ASC
#
LIMIT
#
0,
#
15;
#




# User@Host: motomania[motomania] @ [85.128.186.62]
# # Query_time: 3 Lock_time: 0 Rows_sent: 8 Rows_examined: 644
# use motomania;
# SELECT u.username, u.user_id, u.user_posts, u.user_from,
# u.user_pojazd, u.user_website, u.user_email, u.user_icq, u.user_aim,
# u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,
# u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar,
# u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,
# u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id ,
# p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude,
# m.latitude
# FROM phpbb_posts p, (phpbb_users u LEFT JOIN
# phpbb_map_mod_user m ON u.user_id=m.user_id LEFT JOIN
# phpbb_banlist b ON u.user_id=b.ban_userid), phpbb_posts_text
# pt
# WHERE p.topic_id = 6012
#
# AND pt.post_id = p.post_id
# AND u.user_id =
# p.poster_id
# AND
#
p.post_flagged
# <> 1
#
ORDER
# BY
#
p.post_time
#
ASC
#
LIMIT
#
30,
#
15;
#



# Time: 080608 7:46:23
# # User@Host: motomania[motomania] @ [85.128.186.62]
# # Query_time: 2 Lock_time: 0 Rows_sent: 15 Rows_examined: 2877
# use motomania;
# SELECT u.username, u.user_id, u.user_posts, u.user_from,
# u.user_pojazd, u.user_website, u.user_email, u.user_icq, u.user_aim,
# u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,
# u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar,
# u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,
# u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id ,
# p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude,
# m.latitude
# FROM phpbb_posts p, (phpbb_users u LEFT JOIN
# phpbb_map_mod_user m ON u.user_id=m.user_id LEFT JOIN
# phpbb_banlist b ON u.user_id=b.ban_userid), phpbb_posts_text
# pt
# WHERE p.topic_id = 6975
#
# AND pt.post_id = p.post_id
# AND u.user_id =
# p.poster_id
# AND
#
p.post_flagged
# <> 1
#
ORDER
# BY
#
p.post_time
#
ASC
#
LIMIT
#
45,
#
15;



# User@Host: motomania_1[motomania_1] @ [85.128.186.62]
# # Query_time: 4 Lock_time: 2 Rows_sent: 1 Rows_examined: 37
# use motomania_1;
# SELECT * FROM ads ORDER BY RAND() LIMIT 1;
#

# User@Host: motomania[motomania] @ [85.128.186.62]
# # Query_time: 3 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
# use motomania;
# SELECT *
# FROM phpbb_map_mod_user
# WHERE user_id=585;
#

# User@Host: motomania[motomania] @ [85.128.186.62]
# # Query_time: 3 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
# use motomania;
# SELECT g.group_id, g.group_name
# FROM phpbb_auth_access aa, phpbb_user_group ug, phpbb_groups
# g
# WHERE aa.forum_id = 11
# AND aa.auth_mod = 1
# AND
# g.group_single_user
# = 0
# AND
#
g.group_type
# <> 2
#
AND
#
ug.group_id
#
=
#
aa.group_id
#
AND
#
g.group_id
#
=
#
aa.group_id
#
GROUP
#
BY
#
g.group_id,
#
g.group_name
#
ORDER
#
BY
#
g.group_id;