裏技48-60のSQL
最終更新時間:2011年02月26日 18時12分40秒
---- 裏技48 SELECT '' AS URAWAZA_TANSHO , '48' 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 = '09' -- 阪神 AND (RA.TRACK_CODE = '17' OR RA.TRACK_CODE = '18') -- 芝右内 or 芝右外 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 ; ---- 裏技49 SELECT '' AS URAWAZA_TANSHO , '49*' 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 = '09' -- 阪神 AND (RA.TRACK_CODE = '17' OR RA.TRACK_CODE = '18') -- 芝右内 or 芝右外 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') -- 重賞 or 特別 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 ; ---- 裏技50 SELECT '' AS URAWAZA_TANSHO , '50' 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 = '09' -- 阪神 AND (RA.TRACK_CODE = '17' OR RA.TRACK_CODE = '18') -- 芝右内 or 芝右外 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') -- 重賞 or 特別 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 ; ---- 裏技51 SELECT '' AS URAWAZA_TANSHO , '51*' 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 = '09' -- 阪神 AND (RA.TRACK_CODE = '17' OR RA.TRACK_CODE = '18') -- 芝右内 or 芝右外 AND ( -- 1000万下以下 (RA.KYOSO_JOKEN_CODE_2SAI <> '000' AND (RA.KYOSO_JOKEN_CODE_2SAI <= '010' OR RA.KYOSO_JOKEN_CODE_2SAI >= '701')) OR (RA.KYOSO_JOKEN_CODE_3SAI <> '000' AND (RA.KYOSO_JOKEN_CODE_3SAI <= '010' OR RA.KYOSO_JOKEN_CODE_3SAI >= '701')) OR (RA.KYOSO_JOKEN_CODE_4SAI <> '000' AND RA.KYOSO_JOKEN_CODE_4SAI <= '010') OR (RA.KYOSO_JOKEN_CODE_5SAI_IJO <> '000' AND RA.KYOSO_JOKEN_CODE_5SAI_IJO <= '010') ) 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 ; ---- 裏技52 SELECT '' AS URAWAZA_TANSHO , '52*' 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 = '09' -- 阪神 AND (RA.TRACK_CODE = '17' OR RA.TRACK_CODE = '18') -- 芝右内 or 芝右外 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') -- 重賞 or 特別 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 ; ---- 裏技53 SELECT '' AS URAWAZA_TANSHO , '53' 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 = '09' -- 阪神 AND RA.TRACK_CODE = '24' -- ダート右 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 ; ---- 裏技54 SELECT '' AS URAWAZA_TANSHO , '54*' 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 = '09' -- 阪神 AND RA.TRACK_CODE = '24' -- ダート右 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 ; ---- 裏技55 SELECT '' AS URAWAZA_TANSHO , '55*' 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 = '09' -- 阪神 AND RA.TRACK_CODE = '24' -- ダート右 AND RA.KYORI <= 1400 -- 距離 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 ; ---- 裏技56 SELECT '56' 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 = '09' -- 阪神 AND RA.TRACK_CODE = '24' -- ダート右 AND RA.KYORI = 1800 -- 距離 AND (RA.KYOSO_SHUBETSU_CODE = '11' OR RA.KYOSO_SHUBETSU_CODE = '12') -- 2歳限定、または3歳限定 AND RA.GRADE_CODE = ' ' -- 平場 AND UM.UMABAN = '01' -- 最内 -- 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 ; ---- 裏技57 SELECT '57*' 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 = '09' -- 阪神 AND (RA.TRACK_CODE = '17' OR RA.TRACK_CODE = '18') -- 芝右内 or 芝右外 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 ; ---- 裏技58 SELECT '58' 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 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 = '09' -- 阪神 AND RA.TRACK_CODE = '18' -- 芝右外 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 ; ---- 裏技59 SELECT '59' 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 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 = '09' -- 阪神 AND RA.TRACK_CODE = '24' -- ダート右 AND RA.KYORI = 1800 -- 距離 AND UM.TOZAI_SHOZOKU_CODE = '2' -- 関西の厩舎に所属 AND (KM.TOZAI_SHOZOKU_CODE = '3' OR 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 ; ---- 裏技60 SELECT '60' 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 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 = '09' -- 阪神 AND RA.TRACK_CODE = '24' -- ダート右 AND RA.KYORI = 1800 -- 距離 AND UM.KISHUMEI_RYAKUSHO = '小牧太' AND UM.UMABAN <> ( -- 大外枠 SELECT MAX(UM.UMABAN) FROM JVD_UMAGOTO_RACE_JOHO UM INNER JOIN JVD_RACE_SHOSAI RB ON UM.RACE_CODE = RB.RACE_CODE WHERE 1=1 AND RB.RACE_CODE = RA.RACE_CODE ) -- 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 ;
関連ページ