競馬 |
ここに昔あったデータをMySQLに入れる。
mysql> SELECT stallion FROM blood LIMIT 5; +-----------------+ | stallion | +-----------------+ | A FLEETS DANCER | | A P VALENTINE | | A. P. DELTA | | A. P. JET | | A. P. MILLION | +-----------------+ 5 rows in set (0.01 sec)
DANZIG産句を調べる。
mysql> SELECT COUNT(stallion) FROM blood WHERE sire='DANZIG'; +-----------------+ | COUNT(stallion) | +-----------------+ | 46 | +-----------------+ 1 row in set (0.00 sec)
うえ、46頭もいんのかよ、ってことでMR. PROSPECTORで調べる。
mysql> SELECT COUNT(stallion) FROM blood WHERE sire='MR. PROSPECTOR'; +-----------------+ | COUNT(stallion) | +-----------------+ | 80 | +-----------------+ 1 row in set (0.01 sec)
増えてます。
mysql> SELECT COUNT(stallion) FROM blood WHERE sire='NORTHERN DANCER'; +-----------------+ | COUNT(stallion) | +-----------------+ | 3 | +-----------------+ 1 row in set (0.00 sec)
3頭になった。
mysql> SELECT stallion FROM blood WHERE sire='NORTHERN DANCER'; +----------------+ | stallion | +----------------+ | DANZIG | | DIXIELAND BAND | | OBLIGATO | +----------------+ 3 rows in set (0.01 sec)
mysql> SELECT COUNT(stallion) FROM blood WHERE sire='DIXIELAND BAND'; +-----------------+ | COUNT(stallion) | +-----------------+ | 15 | +-----------------+ 1 row in set (0.00 sec)
mysql> SELECT stallion as s,
-> (SELECT COUNT(stallion) FROM blood WHERE sire = s) AS count
-> FROM blood
-> WHERE (SELECT COUNT(stallion) FROM blood WHERE sire = s) > 1
-> ORDER BY count DESC;
+-------------------+-------+
| s | count |
+-------------------+-------+
| STORM CAT | 102 |
| DANZIG | 46 |
| DEPUTY MINISTER | 38 |
| GONE WEST | 32 |
| A.P. INDY | 29 |
| SEEKING THE GOLD | 17 |
| WILD AGAIN | 16 |
| DIXIELAND BAND | 15 |
| CARSON CITY | 14 |
| MT. LIVERMORE | 13 |
| CRAFTY PROSPECTOR | 11 |
| PHONE TRICK | 10 |
| RUNAWAY GROOM | 9 |
| MEADOWLAKE | 9 |
| KINGMAMBO | 9 |
| DEVIL'S BAG | 9 |
| WOODMAN | 8 |
| GULCH | 8 |
| BROAD BRUSH | 8 |
| IN EXCESS | 7 |
| CRYPTOCLEARANCE | 7 |
| UNBRIDLED'S SONG | 7 |
| TWO PUNCH | 7 |
| HENNESSY | 6 |
| GILDED TIME | 6 |
| MONTBROOK | 5 |
| SLEW CITY SLEW | 5 |
| COZZENE | 5 |
| PINE BLUFF | 4 |
| MARQUETRY | 4 |
| SILVER GHOST | 4 |
| EASTERN ECHO | 4 |
| CHEROKEE RUN | 4 |
| HOLY BULL | 4 |
| SKY CLASSIC | 3 |
| SALT LAKE | 3 |
| SKIP TRIAL | 3 |
| RAHY | 3 |
| PULPIT | 3 |
| CITIDANCER | 3 |
| SILVER DEPUTY | 3 |
| ALYDEED | 3 |
| THUNDER GULCH | 3 |
| HOUSEBUSTER | 3 |
| BERTRANDO | 3 |
| FIT TO FIGHT | 3 |
| MR. GREELEY | 3 |
| BLACK TIE AFFAIR | 2 |
| CEE'S TIZZY | 2 |
| SMOKESTER | 2 |
| STORM BOOT | 2 |
| TOUR D'OR | 2 |
| TAKE ME OUT | 2 |
| THEATRICAL | 2 |
| DAYJUR | 2 |
| DISTANT VIEW | 2 |
| LORD CARSON | 2 |
| HONOUR AND GLORY | 2 |
| GO FOR GIN | 2 |
| PEAKS AND VALLEYS | 2 |
| FAST PLAY | 2 |
| POLISH NAVY | 2 |
| PRIVATE TERMS | 2 |
| PROPER REALITY | 2 |
| QUIET AMERICAN | 2 |
| REGAL CLASSIC | 2 |
| ROBYN DANCER | 2 |
| DYNAFORMER | 2 |
| IS IT TRUE | 2 |
+-------------------+-------+
69 rows in set (3.56 sec)
始めっから調べとけ！
// ==UserScript==
// @name bookmark LDR to MM
// @namespace http://d.hatena.ne.jp/arikui/
// @include http://reader.livedoor.com/reader/
// ==/UserScript==
var w = unsafeWindow;
w.KeyConfig.clipMM = "m";
w.Control.clipMM = function(){
var reg = /\?ref=rss$|\&ref=rss|\?rss=ref$|\&from=rss/;
var item = w.get_active_item(true);
if(!item) return;
var link = "http://1470.net/mm/memo_form.html?url=" + escape(item.link.replace(reg,''));
window.open(link);
}
こんな感じで簡単に使えるのがいいなあ。