SELECT DISTINCT TYPE, SUBBM1, SUBBM2, AGGTYPE, SOURCE, SALESDES, CLASS, APPINF, CATNUM, CATTYPE, REMARKS, CATTYP2 
FROM alltext_models_v 
WHERE ((AGGTYPE = 'HA' OR AGGTYPE = 'VA') AND CLASS = 'A')
ORDER BY SALESDES