ph91.de
  • Home
  • About me
  • Categories
    • Software Development
    • New Zealand
    • Music
    • Tech & IT
    • Sports
    • Dublin
    • Junk
  • Contact
  • Disclaimer
ph91.de
ph91.de
  • Home
  • About me
  • Categories
    • Software Development
    • New Zealand
    • Music
    • Tech & IT
    • Sports
    • Dublin
    • Junk
  • Contact
  • Disclaimer
3
  • Software Development

Speedkini Brand Rankings

  • 1. April 2017
  • No comments
  • 204 views
  • 1 minute read
  • Philipp
Total
0
Shares
0
0
0

In my leisure time, I continue to develop new features for speed-kini.de. The latest addition is a brand ranking which should advise the user on which brand is the fastest. There are three different categories: for board, sail and fin companies. The brands of the first-placed get 30 points, the brands of the second-placed rider get 29 and so on…

The results are computed LIVE using simple SQL and a helper. The helper view produces data like this:

The actual query which produces the ranking looks like this:

SELECT     
      `b`.`name`                                    AS `Name`,     
      sum((31 - `h`.`Rang`))                        AS `Punkte` FROM 
     (`speedkini_ranking_helper` `h`      
JOIN 
    `speedkini_equipment_brand` `b`) WHERE 
     ((`h`.`Boardbrand` = `b`.`ID`) AND (`h`.`Rang` <= 30)) GROUP BY 
     `h`.`Boardbrand` ORDER BY 
     sum((31 - `h`.`Rang`)) DESC;

You can check out the working brand ranking at http://www.speed-kini.de/brand-rangliste/.

 

Total
0
Shares
Like 0
Tweet 0
Pin it 0
Related Topics
  • bayern
  • brand
  • gps
  • speedkini
  • sql
  • windsurf
  • wpDataTables
Philipp

Previous Article
  • Music

Thundercat – “Drunk”

  • 16. March 2017
  • Philipp
View Post
Next Article
  • Software Development

Custom Profiles, REST API and FX with Google Charts

  • 2. April 2017
  • Philipp
View Post
You May Also Like
View Post
  • Software Development

Design Patterns Game

  • 30. April 2019
  • Philipp
View Post
  • Software Development

Unexpected C# Behaviour

  • 16. September 2018
  • Philipp
View Post
  • Software Development

Technical tip: “Can’t find module typescript”

  • 10. September 2018
  • Philipp
View Post
  • Software Development

Speed Kini Features 2018

  • 20. January 2018
  • Philipp
View Post
  • Software Development

Gravity Forms – User Registration fix

  • 17. September 2017
  • Philipp
View Post
  • Software Development
  • Tech & IT

Youtube Development Playlists

  • 16. August 2017
  • Philipp
View Post
  • Software Development

Facebook Authorization error with Kaspersky Internet Security

  • 28. June 2017
  • Philipp
View Post
  • Software Development

Custom Profiles, REST API and FX with Google Charts

  • 2. April 2017
  • Philipp

Leave a Reply Cancel reply

Dev profiles
  • BitBucket
  • Github
  • Stackoverflow
Projects
  • NMF
  • Speed-kini.de
  • Sudoku Solver
Archive
ph91.de
Blog by Philipp Schreitmüller

Input your search keywords and press Enter.

WP DSGVO Tools (GDPR) for Wordpress and WooCommerce We use cookies to give you the best user experience. If you continue to use this site, we assume that you agree. OK Deny