orWhere query shows soft deleted entries

Hi I have the following problem with my query. It shows also the entries from my database which are soft deleted. In the deleted_at there is a date and time but it is still shown in the results. Here is my query maybe Im doing something wrong. Thanks for helping me....

Code:

$data["offeneAnfragen"] = $this->work->where("genehmigt is null", Null)->orWhere('genehmigt', 0)->join("user", "user.id = urlaub.user_id ")->orderBy("user_id")->findAll();

Thanks