SELECT
A.diary_id,
A.diary_name,
A.diary_contents,
A.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.user_name AS create_user_name,
B.image_path,
C.user_name AS update_user_name
FROM user_diary A
INNER JOIN user_info B ON A.create_user = B.user_id
INNER JOIN user_info C ON A.update_user = C.user_id
WHERE B.delete_flag='0' AND B.status_id='1' AND C.delete_flag='0' AND C.status_id='1'
ORDER BY diary_id DESC LIMIT 10 OFFSET 0 クエリ実行エラー
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,
E.image_path,
F.user_name AS update_user_name,
A.place
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
ORDER BY A.witness_id DESC LIMIT 10 OFFSET 0
バスケットボール日記・観戦記
