Detect trending "reactions" (one or more) in an article (Like Buzzfeed and others)
I have a reactions vote system to "tag" my articles with things like: LOL, WTF, OMG, and so on...

I would like to know what would be the best solution to detect what "reactions" are "trending" in that article.

For example: http://www.buzzfeed.com/mjs538/pug-stroller-and-a-baby it,s tagged with WIN, 
CUTE, LOL

![Tagged with WIN, CUTE, LOL][1]


With this votes:

![enter image description here][2]

But this one: http://www.buzzfeed.com/daves4/11-animals-having-their-hearts-tickled-out

Is only tagged as CUTE

![enter image description here][3]

Because the diference between CUTE and the others options is pretty big, regardless of the number of votes itself.

![enter image description here][4]

**I already have the votes for each reaction in my database... So...**

**I would like to know what would be the best way (php or mysql query?) to detect what are the most important reactions...** 

**I'm using PHP and MySQL**

Thanks!


  [1]: http://i.stack.imgur.com/sFeeG.png
  [2]: http://i.stack.imgur.com/f6LfK.png
  [3]: http://i.stack.imgur.com/W8Q6z.png
  [4]: http://i.stack.imgur.com/YxdQI.png
Detect trending "reactions" (one or more) in an article (Like Buzzfeed and others)
===

I have a reactions vote system to "tag" my articles with things like: LOL, WTF, OMG, and so on...

I would like to know what would be the best solution to detect what "reactions" are "trending" in that article.

For example: http://www.buzzfeed.com/mjs538/pug-stroller-and-a-baby it,s tagged with WIN, 
CUTE, LOL

![Tagged with WIN, CUTE, LOL][1]


With this votes:

![enter image description here][2]

But this one: http://www.buzzfeed.com/daves4/11-animals-having-their-hearts-tickled-out

Is only tagged as CUTE

![enter image description here][3]

Because the diference between CUTE and the others options is pretty big, regardless of the number of votes itself.

![enter image description here][4]

**I already have the votes for each reaction in my database... So...**

**I would like to know what would be the best way (php or mysql query?) to detect what are the most important reactions...** 

**I'm using PHP and MySQL**

Thanks!


  [1]: http://i.stack.imgur.com/sFeeG.png
  [2]: http://i.stack.imgur.com/f6LfK.png
  [3]: http://i.stack.imgur.com/W8Q6z.png
  [4]: http://i.stack.imgur.com/YxdQI.png