SELECT hin as 'Health#', demographic_no as 'Demographic#', last_name as 'Last Name', first_name as 'First Name', {location} FROM eChart, demographic WHERE demographicNo=demographic_no {status} && ({location} LIKE '%{search}%' {searchOption2} {searchOption3} {searchOption4} {searchOption5} {searchOption6} ) && demographic_no NOT IN ( SELECT demographic_no FROM dxresearch WHERE dxresearch.status='A' && dxresearch_code IN ( select dxResearchCode FROM quickList WHERE quickListName='{register}' ) ) GROUP BY demographicNo ORDER BY demographic.last_name, demographic.first_name; Ignore AND LIKE ( AND LIKE AND LIKE ) OR LIKE ( OR LIKE OR LIKE ) AND NOT LIKE ( AND NOT LIKE AND NOT LIKE ) OR NOT LIKE ( OR NOT LIKE OR NOT LIKE ) Ignore AND LIKE ( AND LIKE AND LIKE ) OR LIKE ( OR LIKE OR LIKE ) AND NOT LIKE ( AND NOT LIKE AND NOT LIKE ) OR NOT LIKE ( OR NOT LIKE OR NOT LIKE ) Ignore AND LIKE ( AND LIKE AND LIKE ) OR LIKE ( OR LIKE OR LIKE ) AND NOT LIKE ( AND NOT LIKE AND NOT LIKE ) OR NOT LIKE ( OR NOT LIKE OR NOT LIKE ) Ignore AND LIKE ( AND LIKE AND LIKE ) OR LIKE ( OR LIKE OR LIKE ) AND NOT LIKE ( AND NOT LIKE AND NOT LIKE ) OR NOT LIKE ( OR NOT LIKE OR NOT LIKE ) Ignore AND LIKE ( AND LIKE AND LIKE ) OR LIKE ( OR LIKE OR LIKE ) AND NOT LIKE ( AND NOT LIKE AND NOT LIKE ) OR NOT LIKE ( OR NOT LIKE OR NOT LIKE ) CPP Medical History CPP Social History CPP Family History CPP Ongoing Concerns CPP Allergies Encounters Active patients Active and suspended patients Inactive patients All patients select quickListName, quickListName from quickList group by quickListName order by quickListName;