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.date_added OFFSET 1 LIMIT 20 WB Kids
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