RPL Personalization with Last Record Update in Supplemental Table

Hi There,

I've designed an E-mail Campaign using RPL and a SQL View as an Audience. My idea is to send an E-mail when my Customer's product is about to end. Therefore I need to retrieve some information in my Supplemental table ORDERED BY THE LAST UPDATE, which in SQL would be something like ORDER BY MODIFIED_DATE_ DESC, but when I Schedule it uses the last information of my Supplemental table based on CODPRO (SKU/PRODUCT CODE in my Supp).

Here my HTML code with RPL:

<#data PRODUTOS as prod limit=1><#filter CUSTOMER_ID_1=Petz_Nova_Base_Unica.CUSTOMER_ID_><#fields DESCPRO LINKPRO URLPRO><#assign DESCPRO = PRODUTOS.DESCPRO LINKPRO = PRODUTOS.LINKPRO URLPRO = PRODUTOS.URLPRO>                    <table align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="600">                      <tbody>                        <tr>                          <td height="30">                          </td>                        </tr>                        <tr>                          <td align="center" valign="top" width="35%"><a href="${PRODUCT_URL}?utm_source=ClaraVista&utm_medium=crm&utm_campaign=Recompra" target="_blank"><img height="180" src="${URLPRO}" width="180" /></a>                          </td>                          <td style="padding: 0 20px 0;" valign="top" width="65%"><span style="font-size: 23px; color: #007dc5; font-weight: bold; display: block;">${DESCPRO}</span> <a href="${LINKPRO}}?utm_source=ClaraVista&utm_medium=crm&utm_campaign=Recompra" style="display:block; margin-top: 50px;" target="_blank"><img src="btn_rec.jpg" /></a>                          </td>                        </tr>                        <tr>                          <td height="35">                          </td>                        </tr>                      </tbody>                </table>                    </#data>