$deleted_results = array_map(
# Delete each row in select query result 1 by 1.
fn ($x) => $this->db->table('my_table')->where('primary_key', $x['primary_key'])->limit(1)->delete(),
# Query to select rows for deletion.
$this->db->table('my_table')
->select('primary_key')
->where([
'my_type' => 1
])
->orderBy('updated', 'DESC')
->get(reset: true)->getResultArray() ?? []
);