select listName, listType from tbl_LST_partnerLists where ownerId = 4036 and listType = 'system' select * from qmd_lists where listType = 'SYSTEM' and listName not like 'Trade Management%' and ( listName not like 'Operator Import%' or yearImported > '2019' ) and ( listName not like '%CLAIM%' or yearImported > '18' )