Showing Posts For schneiw.4896:
I would be ultra impressed if Anet does a bait n switch and changes some of those requirements at the last minute before releasing the patch
Cool, welcome future damage meters!
Change Top Demanded Items to be by User count instead of individual order volume. If kittens want to manipulate, they will have to buy multiple accounts, a win for Anet.
Select top 10 ItemId, count(UserId)
from Orders
group by ItemId
order by count(UserId) desc
Otherwise algorithm should “normalize” Order quantity (based on total for UserId) based on daily or some other average order size, just adding additional complexity.