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,
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,
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.user_name AS create_user_name,
D.user_name AS update_user_name
FROM team_info A INNER JOIN clubteam_master B ON A.clubteam_id = B.clubteam_id
LEFT OUTER JOIN user_info C ON A.create_user = C.user_id
LEFT OUTER JOIN user_info D ON A.update_user = D.user_id
WHERE A.clubteam_id = AND C.delete_flag = '0' AND D.delete_flag = '0' AND C.status_id = '1' AND D.status_id = '1'
ORDER BY A.clubteam_id ASC,A.history_id DESC LIMIT 30 OFFSET 0 クエリ実行エラー
SELECT COUNT(*) AS all_cnt
FROM team_info A INNER JOIN clubteam_master B ON A.clubteam_id = B.clubteam_id
WHERE A.clubteam_id =
;
バスケットボールコミュニティRokyu.Net
