WITH ids_to_delete  as(
     SELECT rh.dp_value_id
     FROM raw_dp_links rh LEFT OUTER JOIN dp_values dp
     ON  rh.dp_value_id=dp.dp_value_id
     where   dp.dp_value_id is null
     limit 10000
    )
    delete from  raw_dp_links  where dp_value_id  in (select dp_value_id from ids_to_delete)