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 61 LIMIT 20 Ps Technobase
GGGrey
D-GFX Dark Skin
MM515
MySimpleSkin
Black v 2.0
ShiftieVLC
Dark Pepper
Colibri 2
Keagens BlackRed Skin 1.0
Whiteout
Colibri
my_PSP-purple
Home Cinema
LCARS
serpentine
PsVLC
electrix
Nintendo Style
STRYPER-VLC