Advertisement
Guest User

Untitled

a guest
Jan 26th, 2015
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. lichess-main-1(mongod-2.6.5)[PRIMARY] lichess> db.opening_attempt.aggregate({$group:{_id:'$u',nb:{$sum:1}}},{$sort:{nb:-1}},{$limit:10})
  2. {
  3. "result": [
  4. {
  5. "_id": "dmnq",
  6. "nb": 2466
  7. },
  8. {
  9. "_id": "optokopper",
  10. "nb": 1394
  11. },
  12. {
  13. "_id": "nebojsamikic",
  14. "nb": 1276
  15. },
  16. {
  17. "_id": "still_water",
  18. "nb": 1011
  19. },
  20. {
  21. "_id": "checksmix",
  22. "nb": 927
  23. },
  24. {
  25. "_id": "monopo",
  26. "nb": 923
  27. },
  28. {
  29. "_id": "nimzozo",
  30. "nb": 845
  31. },
  32. {
  33. "_id": "atani",
  34. "nb": 807
  35. },
  36. {
  37. "_id": "dolg",
  38. "nb": 793
  39. },
  40. {
  41. "_id": "kapsarov",
  42. "nb": 778
  43. }
  44. ],
  45. "ok": 1
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement