페이지 이력

#중복된 값 찾기
SELECT * FROM AO_92296B_AORECENTLY_VIEWED WHERE USER_KEY = (SELECT USER_KEY FROM user_mapping where lower_username = '<영향받는 유저>') and CONTENT_ID=<로그에 보이는 중복된 키값>;


#예제(현상 로그 참고)
SELECT * FROM AO_92296B_AORECENTLY_VIEWED WHERE USER_KEY = (SELECT USER_KEY FROM user_mapping where lower_username = 'admin') and CONTENT_ID=12589066;
 CONTENT_ID | CONTENT_TYPE |  ID   |     LAST_VIEW_DATE      |    SPACE_KEY    |             USER_KEY
------------+--------------+-------+-------------------------+-----------------+----------------------------------
   12589066 | PAGE         | 19368 | 2021-11-11 13:04:38.461 | MOBILERENEWAL18 | bd7b278159636d7f0159636ed9040000
   12589066 | PAGE         | 19367 | 2021-11-11 13:04:38.46  | MOBILERENEWAL18 | bd7b278159636d7f0159636ed9040000
(2 rows)



#중복된 값 중 하나 지우기
DELETE FROM AO_92296B_AORECENTLY_VIEWED WHERE ID='<ID shown in query output above>';


#예제
DELETE FROM "AO_92296B_AORECENTLY_VIEWED" WHERE "ID"='19368';