  



<!--this is the query update, %GRP% is replaced by AgentList key at web.config-->

  <GET_SUSPECTED_MEMBERS>
    SELECT SUS.USER_ID AS AGENT_ID,SUS.AUTO_ID AS SUS_ID, FIRST_NAME,LAST_NAME,THUMB_URL AS IMAGE_URL, GENDER_ID FROM PM_GRP_MBR SUS (NOLOCK)
    INNER JOIN  FAMILY_MEMBER  FM WITH(NOLOCK)  ON FM.AUTO_ID = SUS.AUTO_ID
    LEFT JOIN  IMG_UP IMG (NOLOCK) ON IMG.AUTO_ID = FM.AUTO_ID AND IMG.IS_DEFAULT = '1'  AND IMG.TP_ID = 'p'  AND (IMG.IS_DEL!=1 OR IMG.IS_DEL IS NULL)
    WHERE SUS.USER_ID = '%USERNAME%' AND SUS.GRP_ID='%GRP%'

  </GET_SUSPECTED_MEMBERS>