Мб? SELECT DISTINCT(user_id) as user_id_dist FROM (SELECT * FROM (SELECT COUNT(*) AS

Question

Мб? SELECT DISTINCT(user_id) as user_id_dist 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 ответов

16 просмотров

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

Александра

Неа, все равно #1060 - Duplicate column name 'user_id' 😔

0

09.09.2020

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

Мб? SELECT DISTINCT(user_id) as user_id_dist FROM (SELECT * FROM (SELECT COUNT(*) AS

1 ответов

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