Ok, fixed it.
I will leave it here for anyone looking for something similar...
PHP Code:
require './auth.php';
$prodId = array(17754, 17755, 17756);
$ids = implode(",",$prodId);
$qry = "SELECT clean_url AS url FROM xcart_clean_urls WHERE resource_id IN ($ids) ";
$resultTst = db_query($qry);
while ($result_row = db_fetch_array($resultTst)) {
echo $result_row['url'];
$urls[] = $result_row;
}