ThekoSyak (05.04.2014 в 22:30)
у меня только что в етой теме такая шняга выскочила
SELECT SQL_CALC_FOUND_ROWS
fm.*, u.username AS username,
u.status AS user_status,
up.avatar AS avatar_exists,
u.last_visit, ff.file_id, ff.file_size,
ff.file_downloads, fv.topic_id,
ff.file_name
FROM a_forum_messages AS
fm
LEFT JOIN a_users AS u USING
(user_id)
LEFT JOIN a_forum_vote AS
fv USING(topic_id)
LEFT JOIN a_users_profiles AS
up USING(user_id)
LEFT JOIN a_forum_files AS ff
USING(message_id)
WHERE fm.topic_id = '40762'
ORDER BY fm.message_id ASC
LIMIT 0, 10
Column 'user_id' in from clause
is ambiguous

ThekoSyak (05.04.2014 в 22:30)
у меня только что в етой теме такая шняга выскочила
SELECT SQL_CALC_FOUND_ROWS
fm.*, u.username AS username,
u.status AS user_status,
up.avatar AS avatar_exists,
u.last_visit, ff.file_id, ff.file_size,
ff.file_downloads, fv.topic_id,
ff.file_name
FROM a_forum_messages AS
fm
LEFT JOIN a_users AS u USING
(user_id)
LEFT JOIN a_forum_vote AS
fv USING(topic_id)
LEFT JOIN a_users_profiles AS
up USING(user_id)
LEFT JOIN a_forum_files AS ff
USING(message_id)
WHERE fm.topic_id = '40762'
ORDER BY fm.message_id ASC
LIMIT 0, 10
Column 'user_id' in from clause
is ambiguous
на запрос похожа

Mobiaaa (05.04.2014 в 22:37)
ThekoSyak (05.04.2014 в 22:30)
у меня только что в етой теме такая шняга выскочила
SELECT SQL_CALC_FOUND_ROWS
fm.*, u.username AS username,
u.status AS user_status,
up.avatar AS avatar_exists,
u.last_visit, ff.file_id, ff.file_size,
ff.file_downloads, fv.topic_id,
ff.file_name
FROM a_forum_messages AS
fm
LEFT JOIN a_users AS u USING
(user_id)
LEFT JOIN a_forum_vote AS
fv USING(topic_id)
LEFT JOIN a_users_profiles AS
up USING(user_id)
LEFT JOIN a_forum_files AS ff
USING(message_id)
WHERE fm.topic_id = '40762'
ORDER BY fm.message_id ASC
LIMIT 0, 10
Column 'user_id' in from clause
is ambiguous
на запрос похожа

Женя!!
Вот ищи вот этот запрос.
И оптимизируй его.
95 % нагрузки от сайта на mysql от подобного запроса