Апелляции блокировок | Прашу знять з бана
у меня только что в етой теме такая шняга выскочила
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
на запрос похожа
________
посл. ред. 05.04.2014 в 22:32; всего 1 раз(а); by ThekoSyak
mr_gamer 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
на запрос похожа
________
посл. ред. 05.04.2014 в 22:32; всего 1 раз(а); by ThekoSyak
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
у меня только что в етой теме такая шняга выскочила
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
лимит обнов
разбанил/этот акк удалил
RezzidenT 
Mobiaaa 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
на запрос похожа
у меня только что в етой теме такая шняга выскочила
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 от подобного запроса
________
посл. ред. 05.04.2014 в 22:38; всего 1 раз(а); by Mobiaaa
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 от подобного запроса
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 от подобного запроса
шта?
