I need DELETED() to be set to on. But I tried to set it to OFF and the results are the same :(

>Exactly. SET DELETED ON can slow down queries. Try the query with SET >DELETED OFF.

>Unfortunately it is in private datasession and deleted() is set to on :(