{"description":"\u516d\u5e16web\u30a2\u30d7\u30ea kickzone/TrainNavi2 \u00b7 GitHub \u4e00\u6628\u65e5\u306e\u61f8\u6848\u3001\u5217\u8eca\u8d70\u884c\u6642\u523b\u304c0\u6642\u3092\u307e\u305f\u3050\u5834\u5408\u3092\u8003\u616e\u3057\u305fSQL\u6587\u3092\u4f5c\u6210\u3057\u305f\u3002 starttime \u3053\u308c\u3092starttime\u304c\u65e5\u4ed8\u3092\u307e\u305f\u3050\u5834\u5408(starttime>endtime)\u3001\u307e\u305f\u304c\u306a\u3044\u5834\u5408(starttime (starttime OR (starttime > endtime AND ((starttime \u307e\u305a\u3053\u3046\u5909\u66f4\u3057\u305f\u3002\u3057\u304b\u3057 FromTime (starttime OR (starttime > endtime AND (starttime \u3068\u306a\u3063\u305f\u3002\u610f\u5916\u306b\u3082\u3059\u3063\u304d\u308a\u3057\u3066\u3044\u308b\u3002\u3053\u308c\u3067\u65b0\u5e79\u7dda\u3084\u9577\u8ddd\u96e2\u7279\u6025\u5217\u8eca\u2026","author_name":"happyholiday","url":"https://rokujo.hatenadiary.com/entry/20141207/1417603467","height":"190","author_url":"https://blog.hatena.ne.jp/happyholiday/","image_url":null,"provider_url":"https://hatena.blog","published":"2014-12-07 19:44:27","blog_url":"https://rokujo.hatenadiary.com/","provider_name":"Hatena Blog","type":"rich","version":"1.0","width":"100%","title":"\u5217\u8eca\u3092\u30b2\u30c3\u30c8\u3059\u308b\u8ad6\u7406\u5909\u66f4\u3001\u5217\u8eca\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u305d\u306e\u5217\u8eca\u306e\u60c5\u5831\u3092\u8868\u793a\u3001\u81ea\u52d5\u753b\u9762\u30b9\u30af\u30ed\u30fc\u30eb\u6a5f\u80fd\u8ffd\u52a0","blog_title":"\u516d\u5e16\u306e\u304b\u305f\u3059\u307f","categories":["\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Frokujo.hatenadiary.com%2Fentry%2F20141207%2F1417603467\" title=\"\u5217\u8eca\u3092\u30b2\u30c3\u30c8\u3059\u308b\u8ad6\u7406\u5909\u66f4\u3001\u5217\u8eca\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u305d\u306e\u5217\u8eca\u306e\u60c5\u5831\u3092\u8868\u793a\u3001\u81ea\u52d5\u753b\u9762\u30b9\u30af\u30ed\u30fc\u30eb\u6a5f\u80fd\u8ffd\u52a0 - \u516d\u5e16\u306e\u304b\u305f\u3059\u307f\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}