SELECT id_product,reference FROM `ps_product` WHERE reference IN ('1897260','6000617424','7685000Q1M','4407219','93867924','FT9001403','808200752R','4396422')Array
(
    [0] => 1897260
    [1] => 6000617424
    [2] => 7685000Q1M
    [3] => 4407219
    [4] => 93867924
    [5] => FT9001403
    [6] => 808200752R
    [7] => 4396422
)
Array
(
)