php - MySQL: order by sum

Solution:

USEORDER BY (stage_1_point+stage_2_point) DESC

So, It will be like

SELECT `id`,
`article_id`,
`stage_1_point`,
`stage_2_point`
FROM YOUR_TABLE ORDER BY (stage_1_point+stage_2_point) DESC
LIMIT 0,10
Copy code

UPDATE

As OP stated, he/she needs to know the position of specific article.

SELECT * FROM (SELECT `id`,
`article_id`,
`stage_1_point`,
`stage_2_point`,
 @curRank := @curRank + 1 AS rank
FROM YOUR_TABLE, (SELECT @curRank := 0) r ORDER BY      
(stage_1_point+stage_2_point) DESC) TAB
WHERE `article_id`=10
Copy code

Above query will return rows for article_id 10, which will have a columnRank which tells the position of the article.

Solution:

You can try below Query as below

Select 
    stage_1_point+stage_2_point as added_point,
    columnsid,
    article_id,
    stage_1_point,
    stage_2_point 
FROM tablename 
ORDER BY 1 desc 
Limit 0,10
Copy code

This will sort data based on column one result and fetch top 10 results only.