$products = array(873, 874, 875);
$sql = 'select * from product_thumbnails where product in (' . implode($products, ', ') . ')';

'select * from product_thumbnails where product in (873, 874, 875)'