SELECT AVG(rating) as avg, COUNT(rating) as count, COUNT(extension_id) as review_nb, skins.id as id, skins.name, author, downloads, date_added, date_modified, image, skins.url, min_version, size FROM skins INNER JOIN "skins-rating" ON skins.id="skins-rating".skin_id LEFT OUTER JOIN reviews ON extension_id=skins.id GROUP BY skins.id, skins.name, skins.author, skins.downloads, skins.date_added, skins.date_modified, skins.image, skins.url, skins.min_version, skins.size ORDER BY avg OFFSET 1 LIMIT 20 Solar
OL Média Player
The New Look
void-r1
Mirror, mirror...
Simple Glass
sandkastenhaut
OL média Player 2
Monster DSi
MiniPlayer DD63
argenta
miniMatrix
Marmor
kastenhaut
DPlayer
ASNO3
WB Kids
Ecco - ColdBlue & FreshGreen
Ecco - SilverEdition
esperanto gnewsense