{"generator":"GNU social 2.0.2-beta0","title":"Conversation","totalItems":1,"items":[{"actor":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/1005-original-20200212031327.gif","rel":"avatar","type":"image\/gif","width":120,"height":120},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-48-20200212035814.gif","rel":"avatar","type":"image\/gif","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-24-20200212035814.gif","rel":"avatar","type":"image\/gif","width":24,"height":24}],"profile_info":{"local_id":"1005"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},"objectType":"person","summary":"<p>Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>","url":"https:\/\/mastodon.zunda.ninja\/users\/zundan","portablecontacts_net":{"preferredUsername":"zundan@mastodon.zunda.ninja","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","note":"<p>Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>"}},"content":"<p>\u5f0a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4eca\u5e74\u306e\u6d41\u884c\u306e\u5909\u5316\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u305f\u304c\u3068\u304f\u306b\u8208\u5473\u6df1\u3044\u50be\u5411\u306f\u898b\u53d7\u3051\u3089\u308c\u307e\u3093\u3067\u3057\u305f\u3002<\/p><p>&gt; SELECT<br \/>date_trunc('week', created_at) as week,<br \/>SUM(CASE WHEN text LIKE '%\u30d0\u30b9\u30bf%' THEN 1 ELSE 0 END) AS basuta,<br \/>SUM(CASE WHEN text LIKE '%\u30d1\u30b9\u30bf%' THEN 1 ELSE 0 END) AS pasuta,<br \/>SUM(CASE WHEN text LIKE '%\u30b9\u30bf\u30d0%' THEN 1 ELSE 0 END) AS sutaba<br \/>FROM statuses<br \/>WHERE created_at &gt; '2018-01-01'<br \/>GROUP BY date_trunc('week', created_at)<br \/>ORDER BY week;<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101328470825508674","object":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101328470825508674","objectType":"note","content":"<p>\u5f0a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4eca\u5e74\u306e\u6d41\u884c\u306e\u5909\u5316\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u305f\u304c\u3068\u304f\u306b\u8208\u5473\u6df1\u3044\u50be\u5411\u306f\u898b\u53d7\u3051\u3089\u308c\u307e\u3093\u3067\u3057\u305f\u3002<\/p><p>&gt; SELECT<br \/>date_trunc('week', created_at) as week,<br \/>SUM(CASE WHEN text LIKE '%\u30d0\u30b9\u30bf%' THEN 1 ELSE 0 END) AS basuta,<br \/>SUM(CASE WHEN text LIKE '%\u30d1\u30b9\u30bf%' THEN 1 ELSE 0 END) AS pasuta,<br \/>SUM(CASE WHEN text LIKE '%\u30b9\u30bf\u30d0%' THEN 1 ELSE 0 END) AS sutaba<br \/>FROM statuses<br \/>WHERE created_at &gt; '2018-01-01'<br \/>GROUP BY date_trunc('week', created_at)<br \/>ORDER BY week;<\/p>","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101328470825508674","status_net":{"notice_id":null}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mastodon.zunda.ninja,2018-12-30:objectId=2619435:objectType=Conversation","notice_info":{"local_id":"1865964","source":"ostatus"}},"published":"2018-12-30T06:02:43+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101328470825508674"}],"links":[{"url":"https:\/\/social.senooken.jp\/conversation\/1319726","rel":"alternate","type":"text\/html"}]}