SELECT
    at.WLSSBACT_DES AS account_type,
    o.WLSUPCOF_EXT_CODE AS tariff_offer_code,
    o.WLSUPCOF_NAME AS tariff_offer_name,
    t.WLSTAR_DES AS tariff,
    cm.SBCAM_DATA_KB,
    cm.SBCAM_BILLPERIOD AS billing,
    COALESCE(s.WLSSBS_IDENTIF_KEY,s.WLSSBS_SERVICE_ID) AS MSISDN,
    wlssbs_id,
    vbi.tarif -- <= tohle hledáš?
FROM P_EDW..wls_sbs_subscribers s
LEFT JOIN P_EDW..wls_sbl_billing_profiles b     ON s.WLSSBS_WLSSBBLP_ID=b.WLSSBBLP_ID
LEFT JOIN P_EDW..wls_sbl_accounts a             ON s.WLSSBS_WLSSBACC_ID=a.WLSSBACC_ID
LEFT JOIN P_EDW..wls_sbl_el_account_types at    ON a.WLSSBACC_WLSSBACT_ID=at.WLSSBACT_ID
LEFT JOIN P_EDW..wls_tariffs t                  ON s.WLSSBS_WLSTAR_ID = t.WLSTAR_ID
LEFT JOIN P_EDW..wls_upc_offers o               ON s.WLSSBS_TAR_WLSUPCOF_ID=o.WLSUPCOF_ID
LEFT JOIN (
    SELECT *, ROW_NUMBER() OVER (partition BY SBCAM_WLSASB_ID, SBCAM_WLSASB_TYPE ORDER BY SBCAM_BILLPERIOD DESC) FROM P_EDW..sb_calc_models
) cm ON cm.SBCAM_WLSASB_ID=s.WLSSBS_ID AND cm.SBCAM_BILLPERIOD>='201901'
LEFT JOIN (
    SELECT
        v.SBVBIM_BILLPERIOD,
        t.WLSTAR_DES AS tarif,
        v.SBVBIM_WLSASB_ID
    FROM Sb_vbi_models v
    LEFT JOIN wls_tariffs t ON v.SBVBIM_WLSTAR_ID = t.WLSTAR_ID
    WHERE
        1=1
        --and SBVBIM_WLSASB_ID = '7448391'
        AND SBVBIM_BILLPERIOD >='201901' -- nechat nějaký ořez na čas
    GROUP BY SBVBIM_BILLPERIOD,SBVBIM_WLSASB_ID, WLSTAR_DES
) vbi ON s.wlssbs_id = vbi.SBVBIM_WLSASB_ID AND cm.SBCAM_BILLPERIOD = vbi.SBVBIM_BILLPERIOD
WHERE
    1=1
    AND WLSSBS_IDENTIF_KEY IN ('601390474', '603412161')
ORDER BY msisdn, billing
LIMIT 1000;