MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;


@@version


10.5.7-MariaDB


CREATE TABLE mvp_alarm(
    id int NOT NULL ,
    mvp_name varchar(255) NOT NULL,
    mvp_location varchar(255) NOT NULL,
    mvp_respawn_start int,
    mvp_respawn_end int,
    PRIMARY KEY (id)
)
CREATE TABLE mvp_tomb(
    id int NOT NULL ,
    mvp_name varchar(255) NOT NULL,
    mvp_location varchar(255) NOT NULL,
    mvp_dead_time time NOT NULL,
    player_name varchar(255) NOT NULL,
    PRIMARY KEY (id)
)
INSERT INTO `mvp_tomb` (`id`, `mvp_name`, `mvp_location`, `mvp_dead_time`, `player_name`) VALUES
(3, 'Atroce', 'ra_fild03', '20:57:14', 'Administrador'),
(2, 'Eddga', 'pay_fild11', '23:03:49', 'Administrador'),
(4, 'Atroce', 'ra_fild02', '14:58:00', 'Administrador'),
(5, 'Atroce', 'ra_fild04', '20:58:41', 'Administrador');
INSERT INTO `mvp_alarm` (`id`, `mvp_name`, `mvp_location`, `mvp_respawn_start`, `mvp_respawn_end`) VALUES
(1, 'Amon Ra', 'moc_pryd06', 60, 70),
(2, 'Atroce', 'ra_fild02', 240, 250),
(3, 'Atroce', 'ra_fild03', 180, 190),
(4, 'Atroce', 'ra_fild04', 300, 310),
(5, 'Atroce', 've_fild01', 180, 190),
(6, 'Atroce', 've_fild02', 360, 370),
(7, 'Bacsojin', 'lou_dun03', 117, 127),
(8, 'Baphomet', 'prt_maze03', 120, 130),
(9, 'Beelzebub', 'abbey03', 720, 730),
(10, 'BioLab3', 'lhz_dun03', 100, 130),
(11, 'Dark Lord', 'gl_chyard', 60, 70),
(12, 'Detale', 'abyss_03', 180, 190),
(13, 'Doppelganger', 'gef_dun02', 120, 130),
(14, 'Dracula', 'gef_dun01', 60, 70),
(15, 'Drake', 'treasure02', 120, 130),
(16, 'Eddga', 'pay_fild11', 120, 130),
(17, 'Evil Snake Lord', 'gon_dun03', 94, 104),
(18, 'Fallen Bishop', 'abbey02', 120, 130),
(19, 'Garm', 'xmas_fild01', 120, 130),
(20, 'Gloom Under Night', 'ra_san05', 300, 310),
(21, 'Golden Thief Bug', 'prt_sewb4', 60, 70),
(22, 'Gopinich', 'mosk_dun03', 120, 130),
(23, 'Ifrit', 'thor_v03', 660, 670),
(24, 'Incantation Samurai', 'ama_dun03', 91, 101),
(25, 'Kiel D-01', 'kh_dun02', 120, 180),
(26, 'Knight of Windstorm', 'xmas_dun02', 60, 70),
(27, 'Lady Tanee', 'ayo_dun02', 420, 430),
(28, 'Lord of Death', 'niflheim', 133, 134),
(29, 'Maya', 'anthell02', 120, 130),
(30, 'Thanatos', 'thana_boss', 120, 121),
(31, 'Mistress', 'mjolnir_04', 120, 130),
(32, 'Moonlight Flower', 'pay_dun04', 60, 70),
(33, 'Nidhoggrs Shadow', '2@nyd', 4320, 4321),
(34, 'Orc Hero', 'gef_fild02', 1440, 1450),
(35, 'Orc Hero', 'gef_fild14', 60, 70),
(36, 'Orc Lord', 'gef_fild10', 120, 130),
(37, 'Osiris', 'moc_pryd04', 60, 70),
(38, 'Pharaoh', 'in_sphinx5', 60, 70),
(39, 'Phreeoni', 'moc_fild17', 120, 130),
(40, 'RSX 0806', 'ein_dun02', 125, 135),
(41, 'Tao Gunka', 'beach_dun', 300, 310),
(42, 'Turtle General', 'tur_dun04', 60, 70),
(43, 'Valkyrie Randgris', 'odin_tem03', 480, 490),
(44, 'Vesper', 'jupe_core', 120, 130),
(45, 'Wounded Morroc', 'moc_fild22', 720, 730);
SELECT `mvp_tomb`.`mvp_dead_time`,`mvp_alarm`.`mvp_respawn_start`, TIME(TIMESTAMP(ADDTIME(`mvp_tomb`.`mvp_dead_time`,SEC_TO_TIME(`mvp_alarm`.`mvp_respawn_start`*60)))) AS respawn_min, DATE_FORMAT(NOW( ), "%H:%i:%S" ) AS hora_actual
FROM `mvp_tomb`
LEFT JOIN `mvp_alarm` ON `mvp_alarm`.`mvp_location` = `mvp_tomb`.`mvp_location`;


mvp_dead_time
mvp_respawn_start
respawn_min
hora_actual


14:58:00
240
18:58:00
22:56:17

20:57:14
180
23:57:14
22:56:17

20:58:41
300
01:58:41
22:56:17

23:03:49
120
01:03:49
22:56:17


    SELECT id FROM (
        SELECT `mvp_tomb`.id,TIME(TIMESTAMP(ADDTIME(
            `mvp_tomb`.`mvp_dead_time`,
            SEC_TO_TIME(`mvp_alarm`.`mvp_respawn_start`*60)
          ))) AS respawn_min, 
          DATE_FORMAT(NOW( ), "%H:%i:%S" ) AS hora_actual 
          FROM `mvp_tomb` LEFT JOIN `mvp_alarm` 
          ON `mvp_alarm`.`mvp_location` = `mvp_tomb`.`mvp_location`
    ) c1 WHERE hora_actual > respawn_min;


id


4

5

2


SELECT * FROM `mvp_tomb`
  WHERE id IN (
    SELECT id FROM (
        SELECT mvp_tomb.id,TIME(TIMESTAMP(ADDTIME(
            `mvp_tomb`.`mvp_dead_time`,
            SEC_TO_TIME(`mvp_alarm`.`mvp_respawn_start`*60)
          ))) AS respawn_min, 
          DATE_FORMAT(NOW( ), "%H:%i:%S" ) AS hora_actual 
          FROM `mvp_tomb` LEFT JOIN `mvp_alarm` 
          ON `mvp_alarm`.`mvp_location` = `mvp_tomb`.`mvp_location`
    ) c1 WHERE hora_actual > respawn_min  
  );


id
mvp_name
mvp_location
mvp_dead_time
player_name


4
Atroce
ra_fild02
14:58:00
Administrador

5
Atroce
ra_fild04
20:58:41
Administrador

2
Eddga
pay_fild11
23:03:49
Administrador
mvp_dead_time	mvp_respawn_start	respawn_min	hora_actual
14:58:00	240	18:58:00	22:56:17
20:57:14	180	23:57:14	22:56:17
20:58:41	300	01:58:41	22:56:17
23:03:49	120	01:03:49	22:56:17
id	mvp_name	mvp_location	mvp_dead_time	player_name
4	Atroce	ra_fild02	14:58:00	Administrador
5	Atroce	ra_fild04	20:58:41	Administrador
2	Eddga	pay_fild11	23:03:49	Administrador