Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/joins_exercises/ja/changes/?format=api
{ "count": 81, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": null, "author": null, "timestamp": "2024-06-26T08:45:25.976669Z", "action": 17, "target": "", "id": 1981731, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1981731/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-06-25T09:31:32.073703Z", "action": 2, "target": "**6列車が通る地区を全てを挙げるとどうなるでしょう?** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます)", "id": 1981708, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1981708/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-06-25T09:09:07.966617Z", "action": 2, "target": "**6系統の列車が走っている地区を全てを挙げるとどうなるでしょう?** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます)", "id": 1981707, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1981707/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": null, "author": null, "timestamp": "2024-03-13T03:45:21.833369Z", "action": 17, "target": "", "id": 1949912, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1949912/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102999/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-03-12T03:36:30.472456Z", "action": 7, "target": "``nyc_neighborhoods``", "id": 1949322, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1949322/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102997/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-03-12T03:36:28.300258Z", "action": 7, "target": "``nyc_subway_stations``", "id": 1949317, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1949317/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102992/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-03-12T03:36:25.903994Z", "action": 7, "target": "``nyc_census_blocks``", "id": 1949312, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1949312/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": null, "author": null, "timestamp": "2024-02-27T02:45:21.788937Z", "action": 17, "target": "", "id": 1949043, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1949043/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102983/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:28:10.372336Z", "action": 26, "target": ":command:`ST_Contains(geometry1, geometry2)` は geometry1 が geometry2 を含む場合に TRUE を返します", "id": 1949019, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1949019/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103007/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:59.155504Z", "action": 7, "target": "**最も人口密度 (人/km2) が高い地区はどこですか?**", "id": 1949018, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1949018/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103006/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:57.051479Z", "action": 7, "target": "**9/11後、'Battery Park' 地区は数日間立ち入り禁止でした。避難しなけれならなかった人の数はどれぐらいでしょうか?**", "id": 1949017, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1949017/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103005/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:54.614226Z", "action": 7, "target": "一つの地区に複数の地下鉄駅がある時に、結果集合から重複値を削除するには ``DISTINCT`` キーワードを使います。", "id": 1949016, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1949016/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:52.343960Z", "action": 7, "target": "**6列車が走っている地区を全てを挙げるとどうなるでしょう?** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます)", "id": 1949015, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1949015/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103007/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:29.941696Z", "action": 4, "target": "**最も人口密度 (人/km2) が高い地区はどこですか?**", "id": 1949014, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1949014/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103006/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:29.929571Z", "action": 4, "target": "**9/11後、'Battery Park' 地区は数日間立ち入り禁止でした。避難しなけれならなかった人の数はどれぐらいでしょうか?**", "id": 1949013, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1949013/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103005/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:29.917502Z", "action": 4, "target": "一つの地区に複数の地下鉄駅がある時に、結果集合から重複値を削除するには ``DISTINCT`` キーワードを使います。", "id": 1949012, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1949012/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:26:29.902319Z", "action": 4, "target": "**6列車が走っている地区を全てを挙げるとどうなるでしょう?** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます)", "id": 1949011, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1949011/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": null, "author": null, "timestamp": "2023-09-16T10:23:38.283151Z", "action": 17, "target": "", "id": 1677460, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1677460/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-09-15T09:35:20.857330Z", "action": 2, "target": "**6列車が走っている町を全てを挙げるとどうなるでしょう?** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます)", "id": 1677424, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1677424/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102979/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:36:15.299696Z", "action": 7, "target": ":command:`count(expression)` はレコードの集合のサイズを返す集約関数です", "id": 1487436, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487436/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102978/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:36:05.999734Z", "action": 26, "target": ":command:`sum(expression)` はレコードの集合の合計を返す集約関数です", "id": 1487435, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1487435/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103007/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:35:56.180757Z", "action": 7, "target": "**最も人口密度 (人/km2) が高い町はどこですか?**", "id": 1487434, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487434/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103006/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:35:48.094719Z", "action": 7, "target": "**9/11後、'Battery Park' 町は数日間立ち入り禁止でした。非難しなけれならなかった人の数はどれぐらいでしょうか?**", "id": 1487433, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487433/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103005/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:35:44.667794Z", "action": 7, "target": "一つの町に複数の地下鉄駅がある時に、結果集合から重複値を削除するには ``DISTINCT`` キーワードを使います。", "id": 1487432, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487432/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:35:36.835924Z", "action": 7, "target": "**6列車が走っている町を全て挙げて下さい** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます。", "id": 1487431, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487431/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103003/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:35:27.806130Z", "action": 7, "target": "**'Little Italy'内にある地下鉄駅はどれでしょう? どの地下鉄路線にありますか?**", "id": 1487430, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487430/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102998/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:35:12.079016Z", "action": 7, "target": "name, routes, geom", "id": 1487429, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487429/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102993/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:34:28.616089Z", "action": 26, "target": "blkid, popn_total, boroname, geom", "id": 1487428, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1487428/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102990/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:34:12.906373Z", "action": 7, "target": ":command:`ST_Within(geometry A, geometry B)` ジオメトリAがジオメトリBの内側にある場合には TRUE を返します", "id": 1487427, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487427/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102989/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:34:00.923943Z", "action": 7, "target": ":command:`ST_Touches(geometry A, geometry B)` ジオメトリAがジオメトリBと接触する場合には TRUE を返します", "id": 1487426, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487426/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102987/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:53.290106Z", "action": 7, "target": ":command:`ST_Intersects(geometry A, geometry B)` ジオメトリAがジオメトリBとインタセクトする場合には TRUE を返します", "id": 1487425, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487425/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102985/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:44.702917Z", "action": 7, "target": ":command:`ST_DWithin(geometry A, geometry B, radius)` ジオメトリAがジオメトリBからの距離が radius 未満の場合には TRUE を返します", "id": 1487424, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487424/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102983/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:40.326020Z", "action": 7, "target": ":command:`ST_Contains(geometry A, geometry B)` ジオメトリAがジオメトリBを含む場合には TRUE を返します", "id": 1487423, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487423/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102979/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:30.803441Z", "action": 7, "target": ":command:`count(expression)`: レコードの集合のサイズを返す集約関数", "id": 1487422, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487422/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102978/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:25.208730Z", "action": 7, "target": ":command:`sum(expression)`: レコードの集合の合計を返す集約関数", "id": 1487421, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487421/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102975/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:18.433612Z", "action": 7, "target": "空間結合の演習", "id": 1487420, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487420/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103007/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.086771Z", "action": 4, "target": "**最も人口密度 (人/km2) が高い町はどこですか?**", "id": 1487419, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487419/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103006/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.082499Z", "action": 4, "target": "**9/11後、'Battery Park' 町は数日間立ち入り禁止でした。非難しなけれならなかった人の数はどれぐらいでしょうか?**", "id": 1487418, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487418/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103005/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.078966Z", "action": 4, "target": "一つの町に複数の地下鉄駅がある時に、結果集合から重複値を削除するには ``DISTINCT`` キーワードを使います。", "id": 1487417, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487417/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.074835Z", "action": 4, "target": "**6列車が走っている町を全て挙げて下さい** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます。", "id": 1487416, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487416/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/103003/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.067255Z", "action": 4, "target": "**'Little Italy'内にある地下鉄駅はどれでしょう? どの地下鉄路線にありますか?**", "id": 1487415, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487415/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102998/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.063294Z", "action": 4, "target": "name, routes, geom", "id": 1487414, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487414/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102990/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.059291Z", "action": 4, "target": ":command:`ST_Within(geometry A, geometry B)` ジオメトリAがジオメトリBの内側にある場合には TRUE を返します", "id": 1487413, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487413/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102989/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.055504Z", "action": 4, "target": ":command:`ST_Touches(geometry A, geometry B)` ジオメトリAがジオメトリBと接触する場合には TRUE を返します", "id": 1487412, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487412/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102987/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.051899Z", "action": 4, "target": ":command:`ST_Intersects(geometry A, geometry B)` ジオメトリAがジオメトリBとインタセクトする場合には TRUE を返します", "id": 1487411, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487411/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102985/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.046604Z", "action": 4, "target": ":command:`ST_DWithin(geometry A, geometry B, radius)` ジオメトリAがジオメトリBからの距離が radius 未満の場合には TRUE を返します", "id": 1487410, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487410/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102983/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.042628Z", "action": 4, "target": ":command:`ST_Contains(geometry A, geometry B)` ジオメトリAがジオメトリBを含む場合には TRUE を返します", "id": 1487409, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487409/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102979/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.038453Z", "action": 4, "target": ":command:`count(expression)`: レコードの集合のサイズを返す集約関数", "id": 1487408, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487408/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102978/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.034523Z", "action": 4, "target": ":command:`sum(expression)`: レコードの集合の合計を返す集約関数", "id": 1487407, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487407/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102975/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-08-30T07:33:10.020826Z", "action": 4, "target": "空間結合の演習", "id": 1487406, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487406/?format=api" } ] }