SELECT
*
FROM (
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 H.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 H ON A.update_user = H.user_id
) G WHERE G.league_id=2
ORDER BY G.game_date DESC LIMIT 30 OFFSET 0 クエリ実行エラー
SELECT
COUNT(*) AS all_cnt
FROM (
SELECT
A.league_id,
A.broadcast_date,
CASE WHEN A.game_date > now() THEN '予定' ELSE '終了' END AS cat,
A.result1,
A.result2,
A.game_id
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
) G WHERE G.league_id=2 クエリ実行エラー
select
league_name
from league_master
where league_id = 2
and delete_flag='0'
の試合情報
