<!--Replace-->


<!-- &lt; replaced by %OPERATOR% -->


  <GENERAL_GET_SM>
    SELECT DISTINCT TOP %RECCOUNT% D.SM_D_ID,FUNCTION_ID,d.SCREEN_NAME,d.auto_id,convert(varchar(10),dp.LAST_UPDATE-1,%DF%) ,D.MODULE_ID,convert(varchar(10),GETDATE(),%DF%)
    FROM SM_DATA D WITH(NOLOCK)
    LEFT JOIN SM_DATA_PROCESS DP WITH(NOLOCK) ON DP.SM_D_ID = D.SM_D_ID and FUNCTION_ID = %1% AND MODULE_ID = %2%
    LEFT JOIN FAMILY_MEMBER FM WITH(NOLOCK) ON FM.AUTO_ID = D.AUTO_ID
    LEFT JOIN FAMILY_DETAILS FD WITH(NOLOCK) ON FD.F_ID = FM.F_ID
    lEFT jOIN PM_GRP_MBR GRP WITH(NOLOCK) ON GRP.AUTO_ID = D.AUTO_ID
    WHERE FUNCTION_ID = %1% AND MODULE_ID = %2% AND (LAST_RUN %OPERATOR% cast(GETDATE() as date) OR LAST_RUN IS NULL)  %COUNTRY% %TYPE% %CAT% %GRP% %ID%
  </GENERAL_GET_SM>




  <NEWS_GET_SM>
    SELECT  AUTO_ID,convert(varchar(10),LAST_RUN_DT-1,%DF%) AS LAST_RUN_DT ,convert(varchar(10),GETDATE(),%DF%) AS DATETO, (SELECT KEYWORDS FROM FT_NEWS_LK WITH(NOLOCK)
    WHERE  ( (CONVERT(DATE,LAST_RUN_DT,%DF%) %OPERATOR% CONVERT(DATE,GETDATE(),%DF%) )
    OR LAST_RUN_DT IS NULL)
    AND (KEYWORDS IS NOT NULL AND KEYWORDS!='')
    AND (IS_DELETED IS NULL OR IS_DELETED= 0)
    AND AUTO_ID = D.AUTO_ID FOR XML PATH('WORDS') , ROOT('Root')) WORDS
    FROM FT_NEWS_LK D WITH(NOLOCK)
    WHERE AUTO_ID IN
    (SELECT  DISTINCT TOP 10 (FM.AUTO_ID) FROM   FT_NEWS_LK LK WITH(NOLOCK)
    INNER JOIN FAMILY_MEMBER  FM WITH(NOLOCK) ON FM.AUTO_ID = LK.AUTO_ID
    LEFT JOIN PM_GRP_MBR GRP WITH(NOLOCK) ON GRP.AUTO_ID = FM.AUTO_ID
    LEFT JOIN FAMILY_DETAILS FD WITH(NOLOCK) ON FD.F_ID = FM.F_ID
    WHERE ( (CONVERT(DATE,LAST_RUN_DT,%DF%) %OPERATOR% CONVERT(DATE,GETDATE(),%DF%) )
    OR LAST_RUN_DT IS NULL)
    AND KEYWORDS IS NOT NULL AND KEYWORDS!=''  %COUNTRY% %TYPE% %CAT% %GRP% %ID% )
    AND (D.IS_DELETED IS NULL OR D.IS_DELETED= 0)
    GROUP BY D.AUTO_ID,D.LAST_RUN_DT
  </NEWS_GET_SM>