裏技61-67のSQL
最終更新時間:2011年08月14日 16時48分51秒
---- 裏技61 SELECT '61' 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 = '01' -- 札幌 AND RA.KYOSO_SHUBETSU_CODE = '11' -- 2歳限定 AND RA.KYOSO_JOKEN_CODE_SAIJAKUNEN = '701' -- 新馬 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 ; ---- 裏技62 SELECT '' AS URAWAZA_TANSHO , '62' 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 = '01' -- 札幌 AND RA.TRACK_CODE = '17' -- 芝 AND RA.KYORI = 1200 -- 距離 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 ; ---- 裏技63 SELECT '63' 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 = '01' -- 札幌 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 ; ---- 裏技64 SELECT '' AS URAWAZA_TANSHO , '64' 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 = '01' -- 札幌 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 ; ---- 裏技65 SELECT '' AS URAWAZA_TANSHO , '65' 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 = '01' -- 札幌 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 ; ---- 裏技66 SELECT '66' 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 = '01' -- 札幌 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 ; ---- 裏技67 SELECT '67' 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 = '01' -- 札幌 AND (RA.KYORI >= 1700 AND RA.KYORI <= 2000)-- 距離 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 ;
関連ページ