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 skins.downloads OFFSET 1 LIMIT 20 kastenhaut
sandkastenhaut
argenta
Monster DSi
MM615
void-r1
OL média Player 2
OL Média Player
Mirror, mirror...
The New Look
raptor
STRYPER-VLC
Marmor
Carbon
Ps Technobase
Ecco - ColdBlue & FreshGreen
esperanto gnewsense
Chelsea VLC
Ecco - UbuntuEdition
Nintendo Style