from (
    -- 앞에서 구한 occurence 에, 인접 세션에 대한 아이템을 붙여준다. (이게 결국 추천이 되어야하는 아이템)
    select
        a.neighbor_session_id,
        a.target_session_id,
        a.target_uid,
        a.neighbor_score,
        b.item_id
    from session_neighbor_occurence a
    inner join session_item_view b on a.neighbor_session_id = b.session_id
)a
left outer join session_item_view b on a.target_session_id = b.session_id and a.item_id = b.item_id
inner join knn_idf c on a.item_id = c.item_id
group by a.target_uid, a.target_session_id, a.item_id

left outer join session_item_view b on a.target_session_id = b.session_id and a.item_id = b.item_id

-- Item:User x User:Item 그래프로 Item:Item 그래프 생성
drop table if exists tmp_p3_iter1;

create table tmp_p3_iter1 as
select item_index1, item_index2, prob
from (
   select
      item_index1, item_index2, prob, row_number() over (partition by item_index1 order by prob desc) as rank
   from
      (
        select
            a.item_index as item_index1,
            b.item_index as item_index2,
            sum(a.prob * b.prob) as prob
        from tmp_p3_graph a
        inner join tmp_p3_graph b
        on a.user_index = b.user_index and a.item_index != b.item_index
        group by a.item_index, b.item_index
   ) a
) a
where rank <= 100;