i am trying to like this as: select name from users, (select A_id , count(*) from event where date<=given date group by A_id order by count(*) desc ) e where users.A_id=e.a_id limit 0,5… OK
i am trying to like this as: select name from users, (select A_id , count(*) from event where date<=given date group by A_id order by count(*) desc ) e where users.A_id=e.a_id limit 0,5… OK