SELECT id_product,reference FROM `ps_product` WHERE reference IN ('1897264','6000617422','7685000Q2A','4407221','93867928','FT9001453','808208208R','828208208R','4396426')Array
(
    [0] => 1897264
    [1] => 6000617422
    [2] => 7685000Q2A
    [3] => 4407221
    [4] => 93867928
    [5] => FT9001453
    [6] => 808208208R
    [7] => 828208208R
    [8] => 4396426
)
Array
(
)