create table links(id1, id2, id3, id4, content) as values (1,2,3,4,'Text') , (1,2,5,4,'Other thing') , (8,4,3,2,'More stuff');

explain select * from links l inner join ( values (1,2,3,4),(1,2,5,4),(8,4,3,2) ) v(id1, id2, id3, id4) using(id1, id2, id3, id4);

-- DANGER! With non-unique values, you get more rows than an IN clause would return select * from links l inner join ( values (1,2,3,4),(1,2,5,4),(1,2,5,4) ) v(id1, id2, id3, id4) using(id1, id2, id3, id4);

-- If you aren't certain, select distinct select * from links l inner join ( select distinct * from (values (1,2,3,4),(1,2,5,4),(1,2,5,4)) vi(id1, id2, id3, id4) ) v using(id1, id2, id3, id4);