Title: Statictic
Last modified: August 21, 2016

---

# Statictic

 *  [ba1udze](https://wordpress.org/support/users/ba1udze/)
 * (@ba1udze)
 * [12 years ago](https://wordpress.org/support/topic/statictic/)
 * Hello
    It would be great have a some more statistic in plugin. For example, my
   players want to know how many prediction for each match, what % for win! for 
   loss! for draw. What a most popular match result (3:1). May be you can do it 
   for the end of World Cup )) Thanks, great plugin!!! I have more than 300 players
   and 5000 prognoses on my site.
 * [https://wordpress.org/plugins/world-cup-predictor/](https://wordpress.org/plugins/world-cup-predictor/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [liorclub](https://wordpress.org/support/users/liorclub/)
 * (@liorclub)
 * [12 years ago](https://wordpress.org/support/topic/statictic/#post-5004784)
 * Good for premium version 🙂
 * I wrote this query for most predicted score by match id
    You can run it on your
   DB and than display it on your website (better than nothing) just change @match_id
   to you match id and run. you can remove LIMIT 1 to get how many predictors for
   each game.
 * SELECT results.score,results.predictors FROM (
    SELECT CONCAT(CAST(home_goals
   AS CHAR(2)), ‘:’,CAST(away_goals AS CHAR(2))) AS score, count(match_id) AS predictors,
   match_id FROM `o4h_wcup_prediction` GROUP BY score , match_id) AS results INNER
   JOIN `o4h_wcup_match` AS matches ON results.match_id = matches.match_id WHERE
   matches.match_id = @match_id ORDER BY results.predictors DESC LIMIT 1
 * Hope it helps 🙂
 *  Plugin Author [landoweb](https://wordpress.org/support/users/landoweb/)
 * (@landoweb)
 * [12 years ago](https://wordpress.org/support/topic/statictic/#post-5004792)
 * Probably will be available in the premium version yes. I’ve got to deploy it 
   on a Predictor of the Championship held in the last 3 years.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Statictic’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/world-cup-predictor.svg)
 * [World Cup Predictor](https://wordpress.org/plugins/world-cup-predictor/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/world-cup-predictor/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/world-cup-predictor/)
 * [Active Topics](https://wordpress.org/support/plugin/world-cup-predictor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/world-cup-predictor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/world-cup-predictor/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [landoweb](https://wordpress.org/support/users/landoweb/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/statictic/#post-5004792)
 * Status: not a support question