95 : SELECT ID,FILEchanged,ACCOUNTstart,ACCOUNTstatus,PERSONfirstname,PERSONlastname,PERSON_city,PERSON_state,PERSON_country
96 : FROM admin879e WHERE (ACCOUNTstart LIKE '%#YEAR#%') AND ((ACCOUNTstatus
97 : = '#stat1#') OR (ACCOUNTstatus = '#stat2#') OR (ACCOUNTstatus = '#stat3#')) AND ((PERSON_city NOT LIKE '#BLANK#') AND (PERSON_city NOT LIKE '%#UNKNOWN#%')) ORDER BY ACCOUNTstart
98 : DESC
99 : </CFQUERY>
|