@Where(clause="DELETE_FLAG is null or DELETE_FLAG=0")

This generates SQL as follows

AND (DELETE_FLAG is null or DELETE_FLAG=0
AND (username is null or username = 'XXX'))
...
It should read

AND ((DELETE_FLAG is null or DELETE_FLAG=0)
AND (username is null or username = 'XXX'))
...