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 101 LIMIT 20 SIMPLy
X-VLC
CompactBlack
hx
universe
Slick Iphone Skin
dno_black
pardus
Debian Red Coast
Heaven - The Better Blissta
JVC-VLC
Orangeade
my_PSP-black
Night
Darkvoodoo
WMP11
WMP11_B - resizable and with total time
pardus white
Crossover Leopard
blackpearl