SELECT S.AS_COMPANY_ID AS COMPANY_ID, S.AS_PRODUCT_ID AS PRODUCT_ID, C.CO_NAME AS COMP_NAME, T.AU_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.AU_CAPTURE AS CAPTURE, T.AU_CAPTURE_URL AS CAPTURE_URL, 'AUTO' AS PROD_TYPE FROM PE_AUTO T INNER JOIN PE_COMPANIES C ON T.AU_COMPANY_ID = C.CO_COMPANY_ID INNER JOIN ( SELECT AS_COMPANY_ID, AS_PRODUCT_ID, MIN(CAST(AS_MON_MIN AS DECIMAL(10, 0))) MONTO_MIN, MAX(CAST(AS_MON_MAX AS DECIMAL(10, 0))) MONTO_MAX, MIN(CAST(AS_MES_MIN AS DECIMAL(10, 0))) MES_MIN, MAX(CAST(AS_MES_MAX AS DECIMAL(10, 0))) MES_MAX, MIN(CAST(AS_TEA_MIN AS DECIMAL(10, 2))) TASA_MIN, MAX(CAST(AS_TEA_MAX AS DECIMAL(10, 2))) TASA_MAX FROM PE_AUTO_SCALES GROUP BY AS_COMPANY_ID, AS_PRODUCT_ID ORDER BY TASA_MIN ASC ) S ON T.AU_PRODUCT_ID = S.AS_PRODUCT_ID WHERE T.AU_ACTIVE <> 'N' AND T.AU_CURRENCY = 'MN' AND T.AU_CAPTURE <> '' AND (C.CO_GEO_COVERAGE LIKE '%LI%' OR C.CO_GEO_COVERAGE ='NACIONAL') group by S.AS_COMPANY_ID ORDER BY TASA_MIN ASC LIMIT 3