SELECT S.PS_COMPANY_ID AS COMPANY_ID, S.PS_PRODUCT_ID AS PRODUCT_ID, C.CO_NAME AS COMP_NAME, T.PR_PROD_NAME AS PROD_NAME, S.MONTO_MIN, S.MONTO_MAX, S.DAY_MIN, S.DAY_MAX, S.TASA_MIN, S.TASA_MAX, C.CO_IMG_URL AS IMG_URL, T.PR_CAPTURE AS CAPTURE, T.PR_CAPTURE_URL AS CAPTURE_URL, 'MICRO' AS PROD_TYPE FROM ES_MICRO_CREDITS T INNER JOIN ES_COMPANIES C ON T.PR_COMPANY_ID = C.CO_COMPANY_ID INNER JOIN ( SELECT PS_COMPANY_ID, PS_PRODUCT_ID, MIN(CAST(PS_MON_MIN AS DECIMAL(10, 0))) MONTO_MIN, MAX(CAST(PS_MON_MAX AS DECIMAL(10, 0))) MONTO_MAX, MIN(CAST(PS_DAY_MIN AS DECIMAL(10, 0))) DAY_MIN, MAX(CAST(PS_DAY_MAX AS DECIMAL(10, 0))) DAY_MAX, MIN(CAST(PS_TEA_MIN AS DECIMAL(10, 2))) TASA_MIN, MAX(CAST(PS_TEA_MAX AS DECIMAL(10, 2))) TASA_MAX FROM ES_MICRO_CREDITS_DETAILS GROUP BY PS_COMPANY_ID, PS_PRODUCT_ID ORDER BY TASA_MIN ASC ) S ON T.PR_PRODUCT_ID = S.PS_PRODUCT_ID WHERE T.PR_ACTIVE <> 'N' AND T.PR_CURRENCY = 'MN' AND T.PR_CAPTURE <> '' AND (C.CO_GEO_COVERAGE LIKE '%LI%' OR C.CO_GEO_COVERAGE ='NACIONAL') group by S.PS_COMPANY_ID ORDER BY PR_PRIORITY DESC, TASA_MIN ASC LIMIT 3