вывести пользователей по рейтингу.

Discussion in 'Болталка' started by superboy4, 27 Jan 2010.

  1. superboy4

    superboy4 Banned

    Joined:
    17 Jul 2007
    Messages:
    151
    Likes Received:
    19
    Reputations:
    -8
    Нужно вывести пользователей по рейтингу
    Code:
    SELECT * FROM users INNER JOIN ratings ON ratings.rateable=users.id ORDER BY SUM(ratings.rating)/COUNT(ratings.rating)
    :( не работает

    ???
     
    #1 superboy4, 27 Jan 2010
    Last edited: 27 Jan 2010
(You must log in or sign up to post here.)