SQL Query for License Tracking

query.sql

DECLARE @licensenumber VARCHAR(20) = '';
DECLARE @user VARCHAR(20) = ''

SELECT DISTINCT app 
FROM applicationauth 
WHERE (optionname='READ' OR optionname='SAVE' OR optionname='DELETE' OR optionname='INSERT') 
    AND groupname IN (SELECT groupuser.groupname FROM groupuser WHERE userid= @user ) 
    AND groupname NOT IN (SELECT varvalue FROM maxvars WHERE varname='ALLUSERGROUP') 
        OR app NOT IN ('PLUSCTMPLT','PLUSTCLAIM','PLUSTCNTMP','PLUSTCOMP','PLUSTCONST','PLUSTCOUNT','PLUSTDTIMP',
          'PLUSTINSP','PLUSTLOGS','PLUSTPOS','PLUSTRS','PLUSTSTKRG','PLUSTTLMCD','PLUSTTMPLT','PLUSTVEND','PLUSTVS',
          'CHANGEPSWD','CONTSFW','RPTOUTPUT','SFWLICVIEW','STARTCNTR','TLOAMSWCTG','PLUSPRESP')) 
    AND NOT EXISTS(SELECT 1 FROM maxlicapps WHERE licensenum=@licensenumber AND maxlicapps.appname= applicationauth.app);