SELECT id_product,reference FROM `ps_product` WHERE reference IN ('1897261','6000617426','7685100Q1K','4407220','93867925','FT9001404','808213720R','4396421')Array
(
    [0] => 1897261
    [1] => 6000617426
    [2] => 7685100Q1K
    [3] => 4407220
    [4] => 93867925
    [5] => FT9001404
    [6] => 808213720R
    [7] => 4396421
)
Array
(
)