Question

一条sql语句返回多个count值

SELECT product_id,team_id,count(team_id) as sum,count(product_id) as sum1 FROM `hits` WHERE (`create_time`>= '1415203200' AND `create_time` <= '1415264663') GROUP BY `team_id`,`product_id` ORDER BY `sum` DESC LIMIT 0,15
第二个group by 被忽略了，为什么，该怎么解决这个问题

Answer 1

你是说order by 忽略了吧

select * from (
SELECT product_id,team_id,count(team_id) as sum,count(product_id) as sum1 FROM `hits` WHERE (`create_time`>= '1415203200' AND `create_time` <= '1415264663') GROUP BY `team_id`,`product_id`
)x
ORDER BY `sum` DESC LIMIT 0,15