<%
set rsbusca = Server.CreateObject("ADODB.Recordset")
rsbusca.ActiveConnection = connStr
rsbusca.Source = "SELECT TOP 10 * FROM tb_MidiaThumb INNER JOIN (tb_MidiaStatus INNER JOIN (tb_Autor INNER JOIN tb_Midia ON tb_Autor.AutorID = tb_Midia.AutorID) ON (tb_MidiaStatus.MidiaStatusID = tb_Midia.MidiaStatusID)) ON (tb_MidiaThumb.ThumbID = tb_Midia.MidiaThumbID) WHERE tb_Midia.MidiaStatusID = " & Request.QueryString("MidiaStatusID") & " AND Inicio < (Date()+1) AND (tb_Midia.Valid=1) Order By tb_Midia.soma_votos Desc, tb_Midia.votos Desc, tb_Midia.clicks Desc"
rsbusca.Open()
%>
a nota media seria o calculo da soma de votos / total de votos, sacou ?
Abraço...