Rating stars backglass

Set of videos to use in a frontend like Pinup Popper to represent playlists based on the rating field in the database. The corresponding database queries could be something like this:

SELECT * FROM games WHERE (GameRating=5) AND visible=1  ORDER BY GameDisplay DESC; 

The better the rating, the more stars are shown behind the text block.

If you need a playlist that lists all unrated games in your database, use something like

SELECT * FROM games WHERE (GameRating IS NULL) AND visible=1  ORDER BY GameDisplay DESC; 

For a playlist with tables ordered by rating:

SELECT * FROM games WHERE (GameRating>0) AND visible=1  ORDER BY GameRating DESC; 

To limit that top rating category by a number (like a top 100 list):

SELECT * FROM games WHERE (GameRating>0) AND visible=1  ORDER BY GameRating DESC LIMIT 100; 

11 star rating loops rolled into one preview:

Corresponding Tarcisio style wheel set: