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 review_nb OFFSET 1 LIMIT 20 DPlayer
Winamp5
Chaos
Void
iTunes
Solar
Vplayer
MediaPlayer
PsVLC
iPod
VLC for kids
Mac OSX Interface (VLC 0.8.4 and older default skin)
Blissta
Dalin Media Player
Askin
uDeluxe
GGGrey
Airflow
WMP11
D-GFX Dark Skin