SELECT
A.witness_id AS witness_id,
A.game_id AS game_id,
A.witness_name AS witness_name,
A.witness_contents AS witness_contents,
A.create_user AS create_user,
TO_CHAR(A.create_date, 'YYYY年MM月DD日 HH24:MI') AS create_date,
A.update_user,
TO_CHAR(A.update_date, 'YYYY年MM月DD日 HH24:MI') AS update_date,
B.game_name AS game_name,
TO_CHAR(B.game_date, 'YYYY年MM月DD日') AS game_date,
B.league_id AS league_id,
B.broadcast_date AS broadcast_date,
B.team1_id AS team1_id,
B.team2_id AS team2_id,
C.clubteam_name AS clubteam1_name,
D.clubteam_name AS clubteam2_name,
B.result1 AS result1,
B.result2 AS result2,
E.user_name AS create_user_name,
F.user_name AS update_user_name
FROM user_witness A INNER JOIN game_master B ON A.game_id = B.game_id
INNER JOIN clubteam_master C ON B.team1_id = C.clubteam_id
INNER JOIN clubteam_master D ON B.team2_id = D.clubteam_id
INNER JOIN user_info E ON A.create_user = E.user_id
INNER JOIN user_info F ON A.update_user = F.user_id
WHERE A.game_id = 5839
ORDER BY A.witness_id DESC
の情報
