createQuery('u') ->where('u.is_active = ?', 1) ->orderBy('u.username ASC') ->execute(); } }