Closed TheForkPower closed 10 months ago
db.user4.aggregate([{$match:{flair:{$exists:1}}},{$sortByCount:'$flair'}])
[
{ _id: 'smileys.alien', count: 1375 },
{ _id: 'activity.chess-pawn', count: 1344 },
{ _id: 'activity.lichess-berserk', count: 1225 },
{ _id: 'smileys.alien-monster', count: 1072 },
{ _id: 'activity.xmas-lichess-horsey', count: 867 },
{ _id: 'activity.1st-place-medal', count: 688 },
{ _id: 'activity.chess', count: 653 },
{ _id: 'nature.fire', count: 644 },
{ _id: 'smileys.ghost', count: 612 },
{ _id: 'smileys.angry-face-with-horns', count: 578 },
{ _id: 'activity.trophy', count: 545 },
{ _id: 'objects.crown', count: 526 },
{ _id: 'smileys.smiling-face-with-sunglasses', count: 524 },
{ _id: 'smileys.clown-face', count: 518 },
{ _id: 'smileys.cold-face', count: 493 },
{ _id: 'activity.lichess-horsey', count: 477 },
{ _id: 'smileys.skull', count: 373 },
{ _id: 'smileys.smiling-face-with-horns', count: 368 },
{ _id: 'smileys.skull-and-crossbones', count: 355 },
{ _id: 'smileys.cowboy-hat-face', count: 311 },
{ _id: 'objects.crossed-swords', count: 285 },
{ _id: 'activity.soccer-ball', count: 280 },
{ _id: 'nature.high-voltage', count: 264 },
{ _id: 'smileys.goblin', count: 248 },
{ _id: 'activity.lichess-variant-atomic', count: 237 },
{ _id: 'smileys.cat-with-wry-smile', count: 228 },
{ _id: 'nature.cat-face', count: 218 },
{ _id: 'activity.christmas-tree', count: 207 },
{ _id: 'symbols.linux-tux-penguin', count: 206 },
{ _id: 'symbols.puzzle-storm', count: 205 },
{ _id: 'travel-places.moai', count: 203 },
{ _id: 'nature.lion', count: 201 },
{ _id: 'activity.lichess-variant-antichess', count: 193 },
{ _id: 'smileys.monka-fbi-glasses', count: 190 },
{ _id: 'objects.gem-stone', count: 189 },
{ _id: 'activity.lichess-hogger', count: 180 },
{ _id: 'smileys.disguised-face', count: 180 },
{ _id: 'nature.bear', count: 171 },
{ _id: 'symbols.pirate-flag', count: 169 },
{ _id: 'smileys.robot', count: 162 },
{ _id: 'smileys.beaming-face-with-smiling-eyes', count: 155 },
{ _id: 'activity.basketball', count: 152 },
{ _id: 'nature.penguin', count: 151 },
{ _id: 'symbols.trident-emblem', count: 150 },
{ _id: 'symbols.double-exclamation-mark', count: 147 },
{ _id: 'smileys.ogre', count: 146 },
{ _id: 'symbols.rainbow-flag', count: 145 },
{ _id: 'smileys.dotted-line-face', count: 143 },
{ _id: 'symbols.zzz', count: 143 },
{ _id: 'nature.goat', count: 139 },
{ _id: 'nature.turtle', count: 137 },
{ _id: 'nature.panda', count: 134 },
{ _id: 'nature.phoenix-bird', count: 133 },
{ _id: 'nature.eagle', count: 129 },
{ _id: 'nature.dragon', count: 127 },
{ _id: 'nature.cyclone', count: 122 },
{ _id: 'people.anatomical-heart', count: 122 },
{ _id: 'smileys.exploding-head', count: 117 },
{ _id: 'smileys.cat-sip', count: 116 },
{ _id: 'smileys.nerd-face', count: 115 }
]
What's with the obsession with aliens 😂 Oh I guess cause it is at the very first row of flairs
is there a list of the most popular flairs?
only on like an /assets/ page, but for devs to see which flairs are faring well. so we can make more like it.