296599 - wrong calculation of rating of themes

Status: RESOLVED DUPLICATE of bug 291413

(www.mozilla.org :: General, defect)

Description

[Marco]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8b2) Gecko/20050523 Firefox/1.0+
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8b2) Gecko/20050523 Firefox/1.0+

The calculation of top rated themes is faulty. The amount of reviews hasn't been
taken into account. e.g. A theme with two positive reviews will always 'win'
from a review with dozens of reviews. The really cool themes (like noia,
abstract, pimpzilla) will receive a lower position in the list in favor of a
theme with less fans. 

Reproducible: Always

Steps to Reproduce:
1.-
2.
3.

Actual Results:  
-

Expected Results:  
-

a query like "SELECT themes ORDER BY rating DESC" isn't enough, it should be
combined with something like "SELECT themes ORDER BY amount_of_reviews DESC".
(i'm no mysql genius)

Comment 1

[Giorgio Maone [:ma1]]

*** This bug has been marked as a duplicate of 291413 ***