I need the SUM of 2 queries than ordered

[XpertWorlock]

Hey guys, I have a SQL query that goes like this

 

SELECT page

FROM keywords

WHERE keyword_id =  '17'

UNION SELECT page

FROM keywords

WHERE keyword_id =  '36'

ORDER BY weight DESC

 

 

SQL TABLE goes as this

 

 

   

keyword_id

   

page

   

weight

 

 

   

17

   

example.php

   

20

 

 

   

36

   

example.php

   

80

 

 

   

17

   

test.php

   

5

 

 

   

36

   

test.php

   

10

 

 

 

So for this example, I need the results to return the "example.php" row first.

I need it to add the 2 weights together (100,15) by page

 

So the outcome would be :

 

example.php

test.php

 

 

Any help guys 

[PFMaBiSmAd]

SELECT page FROM keywords WHERE keyword_id IN(17,36) GROUP BY page ORDER BY SUM(weight) DESC

 

You would only use a UNION when you have more than one table.