{"type":"rich","height":"190","blog_url":"https://oinusama.hatenadiary.org/","width":"100%","blog_title":"\u304a\u3082\u3057\u308d\u65e5\u8a18\u30d1\u30ef\u30fc","title":"UNION\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u9023\u7d50\u3057\u3066\u691c\u7d22\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30af\u30a8\u30ea","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/oinusama/","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Foinusama.hatenadiary.org%2Fentry%2F20090416%2Fp1\" title=\"UNION\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u9023\u7d50\u3057\u3066\u691c\u7d22\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30af\u30a8\u30ea - \u304a\u3082\u3057\u308d\u65e5\u8a18\u30d1\u30ef\u30fc\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"oinusama","provider_name":"Hatena Blog","version":"1.0","description":"hoge0\u3068hoge1\u30c6\u30fc\u30d6\u30eb\u3042\u3063\u305f\u3068\u3059\u308b\u3002 \u305d\u308c\u305e\u308c\u3092dates\u30d5\u30a3\u30fc\u30eb\u30c9\u3067\u964d\u9806\u30bd\u30fc\u30c8\u3057\u3001\u9023\u7d50\u3057\u3066\u5148\u982d\u304b\u30895\u4ef6\u3092\u53d6\u5f97\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u3002 ( SELECT no, name, dates, 0 //\u203b FROM hoge0 ORDER BY dates DESC ) UNION ALL ( SELECT no, name, dates, 1 //\u203b FROM hoge1 ORDER BY dates DESC ) LIMIT 0, 5 \u9023\u7d50\u3057\u3066\u304b\u3089\u30bd\u30fc\u30c8\u3059\u308b\u5834\u5408\u306f\u3001\u6700\u5f8c\u306eLIMIT\u306e\u524d\u3067ORDER BY\u3059\u308b\u3002 \u203b\u306e\u7b87\u6240\u306b\u3064\u3044\u3066 \u7d50\u679c\u30bb\u30c3\u30c8\u306b0\u3068\u3044\u3046\u30d5\u30a3\u30fc\u30eb\u304c\u8ffd\u52a0\u3055\u308c\u3001hoge0\u304b\u3089\u306e\u30ec\u30b3\u30fc\u30c9\u306b\u306f0\u2026","url":"https://oinusama.hatenadiary.org/entry/20090416/p1","published":"2009-04-16 00:00:01","categories":["SQL"]}