裏技1-17のSQL
最終更新時間:2011年01月28日 18時20分52秒
---- 裏技1 SELECT '1*' AS URAWAZA_TANSHO , '' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND RA.KYORI <= 2000 -- 距離 AND (RA.GRADE_CODE = 'A' OR RA.GRADE_CODE = 'B' OR RA.GRADE_CODE = 'C' OR RA.GRADE_CODE = 'D' OR RA.GRADE_CODE = 'E') -- 特別 AND UM.KISHUMEI_RYAKUSHO = '蛯名正義' -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技2 SELECT '2*' AS URAWAZA_TANSHO , '' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND (RA.GRADE_CODE = 'A' OR RA.GRADE_CODE = 'B' OR RA.GRADE_CODE = 'C' OR RA.GRADE_CODE = 'D') -- 重賞 AND PE.KETTO5_BAMEI = 'サンデーサイレンス' -- 母父 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技3 SELECT '' AS URAWAZA_TANSHO , '3*' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND PE.KETTO1_BAMEI = 'ゼンノロブロイ' -- 父 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技4 SELECT '' AS URAWAZA_TANSHO , '4*' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND RA.KYOSO_SHUBETSU_CODE <> '11' -- 2歳限定以外 AND PE.KETTO1_BAMEI = 'キングヘイロー' -- 父 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技5 SELECT '5*' AS URAWAZA_TANSHO , '' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND RA.KYORI = 1600 -- 距離 AND PE.KETTO5_BAMEI = 'トニービン' -- 母父 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技6 SELECT '' AS URAWAZA_TANSHO , '6' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO LEFT OUTER JOIN JVD_KISHU_MASTER KM ON KM.KISHU_CODE = UM.KISHU_CODE WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND RA.KYOSO_SHUBETSU_CODE = '11' -- 2歳限定 AND RA.KYOSO_JOKEN_CODE_SAIJAKUNEN = '701' -- 新馬 AND UM.TOZAI_SHOZOKU_CODE = '2' -- 関西の厩舎に所属 AND KM.TOZAI_SHOZOKU_CODE = '2' -- 関西所属騎手 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技7 SELECT '' AS URAWAZA_TANSHO , '7*' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND (RA.GRADE_CODE = 'A' OR RA.GRADE_CODE = 'B' OR RA.GRADE_CODE = 'C' OR RA.GRADE_CODE = 'D' OR RA.GRADE_CODE = 'E') -- 特別 AND UM.CHOKYOSHIMEI_RYAKUSHO = '鹿戸雄一' -- 調教師名 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技8 SELECT '8*' AS URAWAZA_TANSHO , '' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND RA.KYORI <= 2000 -- 距離 AND UM.CHOKYOSHIMEI_RYAKUSHO = '加藤征弘' -- 調教師名 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技9 -- 前走の情報を保持するテーブルを別途作成 DROP TABLE IF EXISTS URWZ9A; CREATE TEMPORARY TABLE IF NOT EXISTS URWZ9A AS SELECT UM.KETTO_TOROKU_BANGO AS ZENSO_KETTO_TOROKU_BANGO , MAX(RA.RACE_CODE) AS ZENSO_RACE_CODE FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN = '7' AND UM.KETTO_TOROKU_BANGO IN ( SELECT UN.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UN INNER JOIN JVD_RACE_SHOSAI RB ON UN.RACE_CODE = RB.RACE_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UN.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RB.DATA_KUBUN <= '6' AND UN.UMABAN <> '00' -- 馬番 -- AND RB.KEIBAJO_CODE = '05' -- 東京 AND RB.TRACK_CODE = '11' -- 芝左 AND RB.KYORI >= 2400 -- 距離 AND RB.JURYO_SHUBETSU_CODE = '1' -- ハンデ戦 ) GROUP BY UM.KETTO_TOROKU_BANGO ORDER BY RA.RACE_CODE ASC ; DROP TABLE IF EXISTS URWZ9B; CREATE TEMPORARY TABLE IF NOT EXISTS URWZ9B AS SELECT ZENSO_KETTO_TOROKU_BANGO , ZENSO_RACE_CODE , RA.KEIBAJO_CODE AS ZENSO_KEIBAJO_CODE , RA.TRACK_CODE AS ZENSO_TRACK_CODE , RA.KAISAI_NENGAPPI AS ZENSO_NENGAPPI FROM URWZ9A UR INNER JOIN JVD_RACE_SHOSAI RA ON UR.ZENSO_RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE ; SELECT '' AS URAWAZA_TANSHO , '9*' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO --, DATE(UR.ZENSO_NENGAPPI) AS ZENSO_NENGAPPI --,(JULIANDAY(DATE(RA.KAISAI_NENGAPPI)) - JULIANDAY(UR.ZENSO_NENGAPPI)) AS KANKAKU FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE INNER JOIN URWZ9B UR ON UM.KETTO_TOROKU_BANGO = UR.ZENSO_KETTO_TOROKU_BANGO LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '11' -- 芝左 AND RA.KYORI >= 2400 -- 距離 AND RA.JURYO_SHUBETSU_CODE = '1' -- ハンデ戦 AND (JULIANDAY(RA.KAISAI_NENGAPPI) - JULIANDAY(UR.ZENSO_NENGAPPI)) >= 63 -- 前走から中9週以上 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技10 SELECT '' AS URAWAZA_TANSHO , '10' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO LEFT OUTER JOIN JVD_KISHU_MASTER KM ON KM.KISHU_CODE = UM.KISHU_CODE WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND RA.KYORI = 1600 -- 距離 AND KM.TOZAI_SHOZOKU_CODE = '4' -- 海外所属騎手 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技11 -- 前走の情報を保持するテーブルを別途作成 DROP TABLE IF EXISTS URWZ11A; CREATE TEMPORARY TABLE IF NOT EXISTS URWZ11A AS SELECT UM.KETTO_TOROKU_BANGO AS ZENSO_KETTO_TOROKU_BANGO , MAX(RA.RACE_CODE) AS ZENSO_RACE_CODE FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN = '7' AND UM.KETTO_TOROKU_BANGO IN ( SELECT UN.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UN INNER JOIN JVD_RACE_SHOSAI RB ON UN.RACE_CODE = RB.RACE_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UN.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RB.DATA_KUBUN <= '6' AND UN.UMABAN <> '00' -- 馬番 -- AND RB.KEIBAJO_CODE = '05' -- 東京 AND RB.TRACK_CODE = '23' -- ダート左 AND RB.KYORI = 1300 -- 距離 AND RB.KYOSO_SHUBETSU_CODE = '12' -- 3歳 AND RB.KYOSO_JOKEN_CODE_SAIJAKUNEN = '703' -- 未勝利 ) GROUP BY UM.KETTO_TOROKU_BANGO ORDER BY RA.RACE_CODE ASC ; DROP TABLE IF EXISTS URWZ11B; CREATE TEMPORARY TABLE IF NOT EXISTS URWZ11B AS SELECT ZENSO_KETTO_TOROKU_BANGO , ZENSO_RACE_CODE , RA.KEIBAJO_CODE AS ZENSO_KEIBAJO_CODE , RA.TRACK_CODE AS ZENSO_TRACK_CODE , RA.KAISAI_NENGAPPI AS ZENSO_NENGAPPI FROM URWZ11A UR INNER JOIN JVD_RACE_SHOSAI RA ON UR.ZENSO_RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE ; SELECT '' AS URAWAZA_TANSHO , '11' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO --, DATE(UR.ZENSO_NENGAPPI) AS ZENSO_NENGAPPI --,(JULIANDAY(DATE(RA.KAISAI_NENGAPPI)) - JULIANDAY(UR.ZENSO_NENGAPPI)) AS KANKAKU FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE INNER JOIN URWZ11B UR ON UM.KETTO_TOROKU_BANGO = UR.ZENSO_KETTO_TOROKU_BANGO LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND RA.KYORI = 1300 -- 距離 AND RA.KYOSO_SHUBETSU_CODE = '12' -- 3歳 AND RA.KYOSO_JOKEN_CODE_SAIJAKUNEN = '703' -- 未勝利 AND (JULIANDAY(RA.KAISAI_NENGAPPI) - JULIANDAY(UR.ZENSO_NENGAPPI)) >= 63 -- 前走から中9週以上 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技12 -- 前走の情報を保持するテーブルを別途作成 DROP TABLE IF EXISTS URWZ12A; CREATE TEMPORARY TABLE IF NOT EXISTS URWZ12A AS SELECT UM.KETTO_TOROKU_BANGO AS ZENSO_KETTO_TOROKU_BANGO , MAX(RA.RACE_CODE) AS ZENSO_RACE_CODE FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN = '7' AND UM.KETTO_TOROKU_BANGO IN ( SELECT UN.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UN INNER JOIN JVD_RACE_SHOSAI RB ON UN.RACE_CODE = RB.RACE_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UN.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RB.DATA_KUBUN <= '6' AND UN.UMABAN <> '00' -- 馬番 -- AND RB.KEIBAJO_CODE = '05' -- 東京 AND RB.TRACK_CODE = '23' -- ダート左 AND RB.KYORI >= 2100 -- 距離 AND RB.GRADE_CODE = ' ' -- 平場 ) GROUP BY UM.KETTO_TOROKU_BANGO ORDER BY RA.RACE_CODE ASC ; DROP TABLE IF EXISTS URWZ12B; CREATE TEMPORARY TABLE IF NOT EXISTS URWZ12B AS SELECT ZENSO_KETTO_TOROKU_BANGO , ZENSO_RACE_CODE , RA.KEIBAJO_CODE AS ZENSO_KEIBAJO_CODE , RA.TRACK_CODE AS ZENSO_TRACK_CODE , RA.KAISAI_NENGAPPI AS ZENSO_NENGAPPI FROM URWZ12A UR INNER JOIN JVD_RACE_SHOSAI RA ON UR.ZENSO_RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE ; SELECT '' AS URAWAZA_TANSHO , '12' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO --, DATE(UR.ZENSO_NENGAPPI) AS ZENSO_NENGAPPI --,(JULIANDAY(DATE(RA.KAISAI_NENGAPPI)) - JULIANDAY(UR.ZENSO_NENGAPPI)) AS KANKAKU FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE INNER JOIN URWZ12B UR ON UM.KETTO_TOROKU_BANGO = UR.ZENSO_KETTO_TOROKU_BANGO LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND RA.KYORI >= 2100 -- 距離 AND RA.GRADE_CODE = ' ' -- 平場 AND (JULIANDAY(RA.KAISAI_NENGAPPI) - JULIANDAY(UR.ZENSO_NENGAPPI)) >= 63 -- 前走から中9週以上 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技13 SELECT '' AS URAWAZA_TANSHO , '13' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND RA.KYORI >= 1400 -- 距離 AND PE.KETTO1_BAMEI = 'ネオユニヴァース' -- 父 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技14 SELECT '14' AS URAWAZA_TANSHO , '' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND RA.GRADE_CODE = ' ' -- 平場 AND UM.CHOKYOSHIMEI_RYAKUSHO = '白井寿昭' -- 調教師名 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技15 SELECT '' AS URAWAZA_TANSHO , '15' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND UM.CHOKYOSHIMEI_RYAKUSHO = '中竹和也' -- 調教師名 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技16 SELECT '' AS URAWAZA_TANSHO , '16*' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND UM.CHOKYOSHIMEI_RYAKUSHO = '高木登' -- 調教師名 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ; ---- 裏技17 SELECT '' AS URAWAZA_TANSHO , '17' AS URAWAZA_FUKUSHO , DATE(RA.KAISAI_NENGAPPI) AS NENGAPPI , KE.CONTENT AS KEIBAJO , RA.RACE_BANGO AS RACE_BANGO , KS.CONTENT AS KYOSO_SHUBETSU , KJ.CONTENT AS KYOSO_JOKEN , RA.KYOSOMEI_HONDAI AS KYOSO_HONDAI , RA.KYORI AS KYORI , TR.CONTENT AS TRACK , UM.WAKUBAN AS WAKUBAN , UM.UMABAN AS UMABAN , UM.BAMEI AS BAMEI , SE.CONTENT AS SEIBETSU , UM.BAREI AS BAREI , UM.KISHUMEI_RYAKUSHO AS KISHU , UM.FUTAN_JURYO AS KINRYO , UM.CHOKYOSHIMEI_RYAKUSHO AS CHOKYOSHI , PE.KETTO1_BAMEI AS TITI , PE.KETTO5_BAMEI AS HAHATITI , RA.RACE_CODE , UM.KETTO_TOROKU_BANGO FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RA ON UM.RACE_CODE = RA.RACE_CODE LEFT OUTER JOIN JVD_KEIBAJO_CODE KE ON KE.CODE = RA.KEIBAJO_CODE LEFT OUTER JOIN JVD_KYOSO_SHUBETSU_CODE KS ON KS.CODE = RA.KYOSO_SHUBETSU_CODE LEFT OUTER JOIN JVD_KYOSO_JOKEN_CODE KJ ON KJ.CODE = RA.KYOSO_JOKEN_CODE_SAIJAKUNEN LEFT OUTER JOIN JVD_TRACK_CODE TR ON TR.CODE = RA.TRACK_CODE LEFT OUTER JOIN JVD_SEIBETSU_CODE SE ON SE.CODE = UM.SEIBETSU_CODE LEFT OUTER JOIN JVD_KYOSOBA_MASTER PE ON UM.KETTO_TOROKU_BANGO = PE.KETTO_TOROKU_BANGO WHERE 1 = 1 AND RA.DATA_KUBUN <= '6' AND UM.UMABAN <> '00' -- 馬番 -- AND RA.KEIBAJO_CODE = '05' -- 東京 AND RA.TRACK_CODE = '23' -- ダート左 AND RA.KYORI >= 1600 -- 距離 AND UM.CHOKYOSHIMEI_RYAKUSHO = '安田隆行' -- 調教師名 -- GROUP BY RA.RACE_CODE , RA.KAISAI_NENGAPPI , KE.CONTENT , KS.CONTENT , KJ.CONTENT , RA.KYORI , TR.CONTENT , UM.WAKUBAN , UM.UMABAN ORDER BY RA.RACE_CODE ASC ;
関連ページ