MySQL 8.0

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

CREATE TABLE time1
(

prim int (5),
booking int (5) PRIMARY KEY,
duration int (5));
 insert into time1 values 
( 10221877, 296480,30),
( 10221877, 296484,45),
( 10221877, 296487,30),
( 10221877, 296492,40),
( 10221877, 296494,60),
( 10221877, 296510,80),
( 10221877, 296511,11);
CREATE TABLE action1
(

action_id int (5) PRIMARY KEY,
event_id int (5),
link int (5),
text_text VARCHAR(255)

);
insert into action1 values 
(339054,10221877,317547,"text1"),
(339057,10221877,317548,"text2"),
(339061,10221877,317549,"text3"),
(339065,10221877,317551,"text4"),
(339074,10221877,317550,"text5"),
(339075,10221877,317552,"text6");
select action_id,event_id,link,text_text,duration from (
select action1.*,duration,(row_number() over (partition by action1.action_id)) as rowno,
(dense_rank() over (order by action1.action_id)) as groupno  from action1
join time1 on action1.event_id = time1.prim
) as mytable
where mytable.rowno = mytable.groupno




action_id
event_id
link
text_text
duration


339054
10221877
317547
text1
30

339057
10221877
317548
text2
45

339061
10221877
317549
text3
30

339065
10221877
317551
text4
40

339074
10221877
317550
text5
60

339075
10221877
317552
text6
80

action_id	event_id	link	text_text	duration
339054	10221877	317547	text1	30
339057	10221877	317548	text2	45
339061	10221877	317549	text3	30
339065	10221877	317551	text4	40
339074	10221877	317550	text5	60
339075	10221877	317552	text6	80