MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table NEWS (
ID int,
TITLE varchar(15));

insert into NEWS values 
(1,'First new'),
(2,'second new'),
(3,'third new');

create table CATEGORY (
ID int,
TITLE varchar(15));

insert into CATEGORY values 
(1,'Great'),
(2,'Bad'),
(3,'Green');


create table BRIDGE (
ID_NEWS int,
ID_CATEGORY int);

insert into BRIDGE values 
(1,1),
(2,1),
(2,2),
(3,3);
SELECT n.ID,n.TITLE
FROM NEWS n
INNER JOIN BRIDGE b ON n.ID = b.ID_NEWS
WHERE b.ID_CATEGORY IN (1,2,3)
GROUP BY n.ID,n.TITLE


ID
TITLE


1
First new

2
second new

3
third new


SELECT distinct n.TITLE
FROM NEWS n
INNER JOIN BRIDGE b ON n.ID = b.ID_NEWS
WHERE b.ID_CATEGORY IN (1,2,3)


TITLE


First new

second new

third new


SELECT n.ID,n.TITLE,max(b.ID_CATEGORY) as max_ID_CATEGORY
FROM NEWS n
INNER JOIN BRIDGE b ON n.ID = b.ID_NEWS
WHERE b.ID_CATEGORY IN (1,2,3)
GROUP BY n.ID,n.TITLE


ID
TITLE
max_ID_CATEGORY


1
First new
1

2
second new
2

3
third new
3