Мб? SELECT DISTINCT(user_id) FROM (SELECT * FROM (SELECT COUNT(*) AS cnt, user_id

Question

Мб? SELECT DISTINCT(user_id) FROM (SELECT * FROM (SELECT COUNT(*) AS cnt, user_id

FROM users_tags_keys_tmp_1
GROUP BY user_id) AS t
JOIN users_tags_keys_tmp_1 on t.user_id=users_tags_keys_tmp_1.user_id
ORDER BY cnt DESC, t.user_id, key_id) as t2

#backend #php #programming #russian

0

09.09.2020

1 ответов

34 просмотра

Александра · Accepted Answer

Александра

#1060 - Duplicate column name 'user_id'

0

09.09.2020

170 похожих чатов

Мб? SELECT DISTINCT(user_id) FROM (SELECT * FROM (SELECT COUNT(*) AS cnt, user_id

1 ответов

Похожие вопросы