CODE (text):
скопировать код в буфер обмена
скопировать код в буфер обмена
- $rating = mysql_query("SELECT *, MAX(rating*voices*1000+hits) AS koeff
- FROM articles WHERE old_mess = 'old'
- GROUP BY id_category
- HAVING MAX(koeff)
- ORDER BY rating DESC, voices DESC, hits DESC LIMIT 10");