- rtrim: documentation ( source)
- str_repeat: documentation ( source)
<?php
$ids = array(1,2,3,4,5,6,7,8,9,0);
$placeholders = rtrim(str_repeat('?, ', count($ids)), ', ');
$sql = "DELETE FROM elastic_job_ad_queue WHERE locked_by = 0 AND job_ad_id IN ($placeholders)";
echo $sql;