How to change SQL query?

Question

MySQL

And so, there is a request:

SELECT address FROM servers WHERE top = 1 OR vip = 1 ORDER BY date_endtop DESC, date_endvip DESC

It returns and sorts addresses according to two criteria. But if the address falls under top = 1 and vip = 1, then there will be only one address in the list. And I would like the address to be duplicated.

Answer 1

Use Union, something like this:
SELECT address FROM servers WHERE top = 1
UNION
SELECT address from servers where vip = 1
ORDER BY date_endtop DESC, date_endvip DESC

Answer 2

It may be necessary to include the top and vip fields or their sum in the query result. What do you want to get as an output?