SQL SELECT ... WHERE... IN; Any thoughts on getting duplicated values (or a workaround)

Question

I have a question about SQL, in my Python program, i have a list called 'snum' with 900 items containing numbers, some of them are duplicated in the list.

The issue is that at executing the next SQL statement:

db.execute("SELECT id FROM numbers WHERE num IN ({0})".format(', '.join('?' for _in tuple(snum))), tuple(snum))

The returning data contains 414 elements(non duplicated id's).

I need an statement that returns 900 id's, even if they are duplicated.

Can't find a solution. I'm pretty new in the world of programming.

Thanks in advance.

Edit: I'm using SQLite version 3.33.0

Edit2:

Current Workaround is to set a for loop with an sql statement inside:

list = []
for element in snum:
    db.execute("SELECT id FROM numbers WHERE num = ?", (element,))
    sel = db.fetchone()
    list.append(sel[0])

These code creates a list containig the id for every number of the original one (900 id's)

Still not sure if this is the best answer.