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.league_id AS league_id,
A.broadcast_date AS broadcast_date,
A.team1_id AS team1_id,
A.team2_id AS team2_id,
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.result1 AS result1,
A.result2 AS result2,
B.league_id AS league_id1,
B.clubteam_id AS clubteam_id1,
B.clubteam_name AS clubteam_name1,
B.clubteam_kana AS clubteam_kana1,
B.prefecture_id AS prefecture_id1,
B.gender AS gender1,
C.league_id AS league_id2,
C.clubteam_id AS clubteam_id2,
C.clubteam_name AS clubteam_name2,
C.clubteam_kana AS clubteam_kana2,
C.prefecture_id AS prefecture_id2,
C.gender AS gender2,
D.league_name AS league_name,
D.display_order AS display_order,
D.prefecture_nc AS prefecture_nc,
E.user_name AS create_user_name,
F.user_name AS update_user_name,
CASE WHEN A.game_date > now() THEN '予定' ELSE '終了' END AS cat,
CASE WHEN G.user_id IS NULL THEN 'U' ELSE 'A' END AS admin_flg
FROM game_master 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
INNER JOIN league_master D ON A.league_id = D.league_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
LEFT OUTER JOIN admin_user G ON A.update_user = G.user_id
WHERE
E.delete_flag = '0'
AND E.status_id = '1'
AND F.delete_flag = '0'
AND F.status_id = '1'
AND A.game_date > now()
AND A.broadcast_date != ''
ORDER BY A.game_date DESC
LIMIT 10 クエリ実行エラー
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.league_id AS league_id,
A.broadcast_date AS broadcast_date,
A.team1_id AS team1_id,
A.team2_id AS team2_id,
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.result1 AS result1,
A.result2 AS result2,
B.league_id AS league_id1,
B.clubteam_id AS clubteam_id1,
B.clubteam_name AS clubteam_name1,
B.clubteam_kana AS clubteam_kana1,
B.prefecture_id AS prefecture_id1,
B.gender AS gender1,
C.league_id AS league_id2,
C.clubteam_id AS clubteam_id2,
C.clubteam_name AS clubteam_name2,
C.clubteam_kana AS clubteam_kana2,
C.prefecture_id AS prefecture_id2,
C.gender AS gender2,
D.league_name AS league_name,
D.display_order AS display_order,
D.prefecture_nc AS prefecture_nc,
CASE WHEN A.game_date <= now() THEN '予定' ELSE '終了' END AS cat,
CASE WHEN G.user_id IS NULL THEN 'U' ELSE 'A' END AS admin_flg
FROM game_master 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
INNER JOIN league_master D ON A.league_id = D.league_id
LEFT OUTER JOIN admin_user G ON A.update_user = G.user_id
WHERE
A.game_date <= now()
AND A.result1 >= 0
AND A.result2 >=0
ORDER BY A.game_date DESC
LIMIT 10 クエリ実行エラー
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.league_id AS league_id,
A.broadcast_date AS broadcast_date,
A.team1_id AS team1_id,
A.team2_id AS team2_id,
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.result1 AS result1,
A.result2 AS result2,
B.league_id AS league_id1,
B.clubteam_id AS clubteam_id1,
B.clubteam_name AS clubteam_name1,
B.clubteam_kana AS clubteam_kana1,
B.prefecture_id AS prefecture_id1,
B.gender AS gender1,
C.league_id AS league_id2,
C.clubteam_id AS clubteam_id2,
C.clubteam_name AS clubteam_name2,
C.clubteam_kana AS clubteam_kana2,
C.prefecture_id AS prefecture_id2,
C.gender AS gender2,
D.league_name AS league_name,
D.display_order AS display_order,
D.prefecture_nc AS prefecture_nc,
CASE WHEN A.game_date >= now() THEN '予定' ELSE '終了' END AS cat,
CASE WHEN G.user_id IS NULL THEN 'U' ELSE 'A' END AS admin_flg
FROM game_master 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
INNER JOIN league_master D ON A.league_id = D.league_id
LEFT OUTER JOIN admin_user G ON A.update_user = G.user_id
WHERE
A.game_date > now() + CAST('-1 days' AS INTERVAL)
AND A.result1 < 0
AND A.result2 < 0
ORDER BY A.game_date ASC
LIMIT 10 クエリ実行エラー
SELECT
A.league_id,
A.league_name,
A.display_order,
A.prefecture_nc,
A.gender_nc,
(select count(*) from clubteam_master where league_id = A.league_id) as num_of_teams
FROM league_master A
ORDER BY display_order ASC;
バスケットボール試合情報
