I have a table with five fields:

ITEMS
id
title
text
rating
numvotes

I want to order the items by their rating.

First approach:

Code:
SELECT * FROM items ORDER BY rating DESC LIMIT 10;
Not very good.

Second approach:

Code:
SELECT * FROM items ORDER BY rating DESC WHERE numvotes > 5 LIMIT 10;
Better.

However, I would like it that the following:

Code:
rating: 4,3   (out of 5)
numvotes 150
would score higher than

Code:
rating 4,4
numvotes 10
Since it has alot more votes and is thus a better representation.

How would I be able to do something like that?