SELECT -- 1. uzd
NAME AS vards,
DAY AS diena
FROM
namsday
WHERE
WEEK(STR_TO_DATE(CONCAT(DAY, '-', MONTH, '-2025'), '%d-%m-%Y')) =
WEEK((SELECT MIN(STR_TO_DATE(CONCAT(DAY, '-', MONTH, '-2025'), '%d-%m-%Y'))
FROM namsday
WHERE name = 'Eriks'))

UNION ALL

SELECT -- 2. uzd
NAME AS vards,
DAY AS diena
FROM
namsday
WHERE
LENGTH(name) = LENGTH('Eriks')

UNION ALL

SELECT -- 3. uzd
NAME AS vards,
DAY AS diena
FROM
namsday
WHERE
LENGTH(name) = LENGTH('Kemlers')

UNION all

SELECT -- 4. uzd
NAME AS vards,
CONCAT(DAY, '-', MONTH, '-2025') AS diena
FROM
namsday
WHERE
(NAME LIKE 'E%' AND NAME LIKE '%s')
OR 
(CONCAT(DAY, '-', MONTH, '-2025') LIKE 'E%' AND CONCAT(DAY, '-', MONTH, '-2025') LIKE '%s')

UNION all

SELECT -- 5. uzd
NAME AS vards,
CONCAT(DAY, '-', MONTH, '-2025') AS diena
FROM
namsday
WHERE
NAME LIKE '%s'
OR 
(CONCAT(DAY, '-', MONTH, '-2025') LIKE '%s')

UNION ALL

SELECT -- 6. uzd
NAME AS vards,
CONCAT(DAY, '-', MONTH, '-2025') AS diena
FROM
namsday
WHERE
STR_TO_DATE(CONCAT(DAY, '-', MONTH, '-2025'), '%d-%m-%Y') > STR_TO_DATE('18-05-2025', '%d-%m-%Y')

UNION ALL

SELECT -- 7. uzd
NAME AS vards,
CONCAT(DAY, '-', MONTH, '-2025') AS diena
FROM
namsday
WHERE
name LIKE 'E%'
ORDER BY
'month' DESC,
'day' ASC;