<cfquery name="getMailingList" datasource="#request.DBDatasource#" username="#request.DBUsername#" password="#request.DBPassword#">
            DECLARE @list INT
            SET @list=<cfqueryparam cfsqltype="CF_SQL_INTEGER" VALUE="#form.RMU_ID#">

            SELECT rmp.RMP_ID, #ArrayToList(UserFieldArray)#, rmpl.RMPL_UUID
            FROM #request.DBTablePrefix#REG_MAILPEOPLELIST rmpl
                INNER JOIN #request.DBTablePrefix#REG_MAILPEOPLE rmp ON rmpl.RMPL_RMP_ID = rmp.RMP_ID
                    AND rmp.RMP_ACTIVE IS NOT NULL
            WHERE rmpl.RMPL_RMU_ID = @list

            UNION

            SELECT -1 * rg.RG_ID AS RMP_ID
            <cfloop INDEX="i" FROM="1" TO="#ArrayLen(UserRegArray)#">
                <cfif ListFindNoCase(getRegFieldsList, UserRegArray[i])>
                    <cfset RegGroupFieldList=ListAppend(RegGroupFieldList, UserRegArray[i])>
                    , rg.#UserRegArray[i]# AS #UserFieldArray[i]#
                <cfelse>
                    , '' AS #UserFieldArray[i]#
                </cfif>
            </cfloop>
                , rmpl.RMPL_UUID
            FROM #request.DBTablePrefix#REGISTRATION rg
                INNER JOIN #request.DBTablePrefix#REG_MAILPEOPLELIST rmpl ON rmpl.RMPL_RMP_ID = -1 * rg.RG_ID
                    AND rmpl.RMPL_RMU_ID = @list
                INNER JOIN #request.DBTablePrefix#REG_MAILPEOPLELIST rmpl_2 ON rmpl_2.RMPL_RMP_ID = -1 * rg.RG_ID
            WHERE rmpl.RMPL_RMU_ID = @list

            ORDER BY RMP_LASTNAME, RMP_FIRSTNAME
        </cfquery>