MySQL 8.0

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

create table t1  (
  id int ,
  substance_id int  ,
  filter_id int
);

insert into t1 values 
(7892022,26,2681),
(7892021,750,2680),
(7892020,750,2679),
(7892019,750,2677),
(7892018,750,2676),
(7892017,300,2680),
(7892016,300,2679),
(7892015,20,2681),
(7892014,20,2677),
(7892013,5,2681),
(7892012,5,2680),
(7892011,5,2679),
(7892010,5,2678),
(7892009,5,2677),
(7892008,5,2676);

Records: 15  Duplicates: 0  Warnings: 0


select * from t1


id
substance_id
filter_id


7892022
26
2681

7892021
750
2680

7892020
750
2679

7892019
750
2677

7892018
750
2676

7892017
300
2680

7892016
300
2679

7892015
20
2681

7892014
20
2677

7892013
5
2681

7892012
5
2680

7892011
5
2679

7892010
5
2678

7892009
5
2677

7892008
5
2676


select substance_id 
from t1
where filter_id in (2676,2677,2678)
group by substance_id
having count(distinct filter_id) = 3;


substance_id


5

id	substance_id	filter_id
7892022	26	2681
7892021	750	2680
7892020	750	2679
7892019	750	2677
7892018	750	2676
7892017	300	2680
7892016	300	2679
7892015	20	2681
7892014	20	2677
7892013	5	2681
7892012	5	2680
7892011	5	2679
7892010	5	2678
7892009	5	2677
7892008	5	2676