How to build a SQL query to get shares depending on the end date?

Question

SQL

Figuratively, there should be 2 parts: active and inactive.
It is necessary to fit everything into one request.
Example of received data:
End date (Just ascending dates starting from today):

• today
  
• tomorrow
  
• a week later
  
• in a month
  

(and in the same issue you need to get past promotions)
(Just descending dates starting from today):

• yesterday
  
• the day before yesterday
  
• a week ago
  

Answer 1

Wouldn't like to use

isActive

, because this field will have to be updated every time when accessing promotions
At the moment, I googled this option

SELECT * FROM special WHERE date_end > NOW()
UNION
SELECT * FROM special WHERE  date_end < NOW()

And it seems to even solve the sorting problem, although it is not set here, but the output is correct

Answer 2

For activity / inactivity, add a calculated field to the query output: DATE(NOW()) <= date_end AS isActive
To group by yesterday / the day before yesterday, you will have to sequentially compare the date with

CASE TRUE
WHEN date_end >= DATE_ADD(NOW(), INTERVAL 1 WEEK))
  AND date_end < DATE_ADD(NOW(), INTERVAL 1 MONTH))  THEN "через месяц"
WHEN date_end >= DATE_ADD(NOW(), INTERVAL 1 DAY))
  AND date_end < DATE_ADD(NOW(), INTERVAL 1 WEEK))  THEN "через неделю"
...
END AS kogda

and similar