How to output duplicates with a specific pk in postgre?

Question

PostgreSQL

There is a table. It is necessary to transfer volumio_id from the Django web muzzle. For example, volumio_id=[6,7, 2] and it shows me the general entries for these IDs. In this case it would be name="11_You_Wish.mp3". Search by name.
I need help in building a request so that I can send IDs there, and in response I get common songs. Or how to do it through ORM Djano

Answer 1

SELECT 1 as id, volo_files.name, string_agg(CAST(volo_files.volumio_id AS TEXT), ', ') AS volumio_ids, count(volo_files.name) as cnt
from volo_files
where volumio_id in %s
GROUP BY volo_files.name
HAVING count(volo_files.name) > 1

I made this request