SELECT
A.league_id AS league_id,
A.clubteam_id AS clubteam_id,
A.clubteam_name AS clubteam_name,
A.clubteam_kana AS clubteam_kana,
A.prefecture_id AS prefecture_id,
A.gender AS gender,
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,
A.delete_flag AS delete_flag,
B.league_name AS league_name,
B.display_order AS display_order,
B.prefecture_nc AS prefecture_nc,
B.gender_nc AS gender_nc,
C.prefecture AS prefecture_name,
D.user_name AS create_user_name,
E.user_name AS update_user_name
FROM clubteam_master A INNER JOIN league_master B ON A.league_id = B.league_id
LEFT OUTER JOIN prefecture_master C ON A.prefecture_id = C.prefecture_id
LEFT OUTER JOIN user_info D ON A.create_user = D.user_id
LEFT OUTER JOIN user_info E ON A.update_user = E.user_id
WHERE A.clubteam_id = 797 AND D.delete_flag='0' AND E.delete_flag='0' AND D.status_id='1' AND E.status_id='1'; クエリ実行エラー
SELECT
A.clubteam_id AS clubteam_id,
A.history_id AS history_id,
A.clubteam_summary AS clubteam_summary,
A.clubteam_record AS clubteam_record,
A.clubteam_feature AS clubteam_feature,
B.league_id AS league_id,
B.clubteam_name AS clubteam_name,
B.clubteam_kana AS clubteam_kana,
B.prefecture_id AS prefecture_id,
B.gender AS gender,
C.prefecture_nc AS prefecture_nc,
C.gender_nc AS gender_nc,
D.prefecture AS prefecture_name,
C.league_name AS league_name
FROM team_info A INNER JOIN clubteam_master B ON A.clubteam_id = B.clubteam_id
INNER JOIN league_master C ON B.league_id = C.league_id
LEFT OUTER JOIN prefecture_master D ON B.prefecture_id = D.prefecture_id
WHERE A.clubteam_id = 797 AND
A.history_id = (SELECT MAX(history_id) FROM team_info WHERE clubteam_id = 797)
; クエリ実行エラー
SELECT
A.game_id AS game_id,
A.game_name AS game_name,
TO_CHAR(A.game_date, 'YYYY年MM月DD日') AS game_date,
A.team1_id AS team1_id,
B.clubteam_name AS team1_name,
A.team2_id AS team2_id,
C.clubteam_name AS team2_name,
A.result1 AS result1,
A.result2 AS result2,
D.prefecture AS prefecture1_name,
E.prefecture AS prefecture2_name
FROM
((SELECT * FROM
game_master
WHERE
(team1_id = 797 OR team2_id = 797)
AND
game_date > now()
ORDER BY
game_date DESC
LIMIT 5
) UNION ALL (
SELECT * FROM game_master
WHERE
(team1_id = 797 OR team2_id = 797)
AND
game_date < now()
ORDER BY
game_date DESC
LIMIT 5)) A
INNER JOIN clubteam_master B ON A.team1_id = B.clubteam_id
INNER JOIN clubteam_master C ON A.team2_id = C.clubteam_id
LEFT OUTER JOIN prefecture_master D ON B.prefecture_id = D.prefecture_id
LEFT OUTER JOIN prefecture_master E ON C.prefecture_id = E.prefecture_id
order by A.game_date desc
; クエリ実行エラー
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 B.team1_id = 797 OR B.team2_id = 797
AND E.delete_flag = '0' AND E.status_id = '1' AND F.delete_flag = '0' AND F.status_id = '1'
ORDER BY A.witness_id DESC LIMIT 5
のバスケットボール情報
