SELECT S.LL_COMPANY_ID AS COMPANY_ID, S.LL_PRODUCT_ID AS PRODUCT_ID, C.CO_NAME AS COMP_NAME, T.LO_PROD_NAME AS PROD_NAME, S.MONTO_MIN, S.MONTO_MAX, S.MES_MIN, S.MES_MAX, S.TASA_MIN, S.TASA_MAX, C.CO_IMG_URL AS IMG_URL, T.LO_CAPTURE AS CAPTURE, T.LO_CAPTURE_URL AS CAPTURE_URL, 'PRESTAMOS' AS PROD_TYPE FROM MX_LOANS T INNER JOIN MX_COMPANIES C ON T.LO_COMPANY_ID = C.CO_COMPANY_ID INNER JOIN ( SELECT LL_COMPANY_ID, LL_PRODUCT_ID, MIN(CAST(LL_MON_MIN AS DECIMAL(10, 0))) MONTO_MIN, MAX(CAST(LL_MON_MAX AS DECIMAL(10, 0))) MONTO_MAX, MIN(CAST(LL_MES_MIN AS DECIMAL(10, 0))) MES_MIN, MAX(CAST(LL_MES_MAX AS DECIMAL(10, 0))) MES_MAX, MIN(CAST(LL_TEA_MIN AS DECIMAL(10, 2))) TASA_MIN, MAX(CAST(LL_TEA_MAX AS DECIMAL(10, 2))) TASA_MAX FROM MX_LOAN_SCALES GROUP BY LL_COMPANY_ID, LL_PRODUCT_ID ORDER BY TASA_MIN ASC ) S ON T.LO_PRODUCT_ID = S.LL_PRODUCT_ID WHERE T.LO_ACTIVE <> 'N' AND T.LO_CURRENCY = 'MN' AND T.LO_CAPTURE <> '' AND (C.CO_GEO_COVERAGE LIKE '%LI%' OR C.CO_GEO_COVERAGE ='NACIONAL') group by S.LL_COMPANY_ID ORDER BY TASA_MIN ASC LIMIT 3