SELECT
A.diary_comment_id AS diary_comment_id,
A.diary_id AS diary_id,
A.diary_comment AS diary_comment,
A.create_user AS create_user,
TO_CHAR(A.create_date, 'YYYY/MM/DD HH24:MI:SS') AS create_date,
A.update_user AS update_user,
TO_CHAR(A.update_date, 'YYYY/MM/DD HH24:MI:SS') AS update_date,
B.diary_name AS diary_name,
B.diary_contents AS diary_contents,
C.user_name AS create_user_name,
D.user_name AS update_user_name
FROM user_diary_comment A INNER JOIN user_diary B ON A.diary_id = B.diary_id
INNER JOIN user_info C ON A.create_user = C.user_id
INNER JOIN user_info D ON A.update_user = D.user_id
WHERE C.delete_flag ='0' AND C.status_id = '1' AND D.delete_flag ='0' AND D.status_id = '1'
AND A.diary_id =
ORDER BY A.update_date DESC;
「」
