Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/joins/changes/?format=api&page=5
{ "count": 340, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/changes/?format=api&page=6", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/changes/?format=api&page=4", "results": [ { "unit": "https://weblate.osgeo.org/api/units/2236815/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188853Z", "action": 59, "target": "", "id": 1948826, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948826/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236814/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188801Z", "action": 59, "target": "", "id": 1948825, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948825/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236813/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188750Z", "action": 59, "target": "", "id": 1948824, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948824/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236812/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188698Z", "action": 59, "target": "", "id": 1948823, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948823/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236811/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188646Z", "action": 59, "target": "", "id": 1948822, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948822/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236810/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188595Z", "action": 59, "target": "", "id": 1948821, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948821/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236809/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188543Z", "action": 59, "target": "", "id": 1948820, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948820/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236808/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188491Z", "action": 59, "target": "", "id": 1948819, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948819/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236807/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188437Z", "action": 59, "target": "", "id": 1948818, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948818/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236806/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188385Z", "action": 59, "target": "", "id": 1948817, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948817/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236805/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188332Z", "action": 59, "target": "", "id": 1948816, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948816/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236804/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188277Z", "action": 59, "target": "", "id": 1948815, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948815/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236803/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188213Z", "action": 59, "target": "", "id": 1948814, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948814/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236802/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188159Z", "action": 59, "target": "", "id": 1948813, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948813/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236801/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188099Z", "action": 59, "target": "", "id": 1948812, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948812/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236800/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188033Z", "action": 59, "target": "", "id": 1948811, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948811/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236799/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187963Z", "action": 59, "target": "", "id": 1948810, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948810/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236798/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187911Z", "action": 59, "target": "", "id": 1948809, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948809/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236797/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187855Z", "action": 59, "target": "", "id": 1948808, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948808/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236796/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187783Z", "action": 59, "target": "", "id": 1948807, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948807/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236795/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187731Z", "action": 59, "target": "", "id": 1948806, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948806/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236794/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187680Z", "action": 59, "target": "", "id": 1948805, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948805/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236793/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187629Z", "action": 59, "target": "", "id": 1948804, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948804/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236792/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187577Z", "action": 59, "target": "", "id": 1948803, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948803/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236791/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187525Z", "action": 59, "target": "", "id": 1948802, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948802/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236790/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187474Z", "action": 59, "target": "", "id": 1948801, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948801/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236789/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187422Z", "action": 59, "target": "", "id": 1948800, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948800/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236788/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187370Z", "action": 59, "target": "", "id": 1948799, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948799/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236787/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187317Z", "action": 59, "target": "", "id": 1948798, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948798/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236786/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187265Z", "action": 59, "target": "", "id": 1948797, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948797/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236785/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187212Z", "action": 59, "target": "", "id": 1948796, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948796/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236784/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187157Z", "action": 59, "target": "", "id": 1948795, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948795/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236783/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.187086Z", "action": 59, "target": "", "id": 1948794, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948794/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/zcw5/?format=api", "author": "https://weblate.osgeo.org/api/users/zcw5/?format=api", "timestamp": "2024-02-26T05:09:24.983973Z", "action": 48, "target": "", "id": 1948793, "action_name": "Language added", "url": "https://weblate.osgeo.org/api/changes/1948793/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/zcw5/?format=api", "author": null, "timestamp": "2024-02-26T05:09:24.979799Z", "action": 17, "target": "", "id": 1948792, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1948792/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": null, "user": null, "author": null, "timestamp": "2023-10-19T03:55:12.719806Z", "action": 47, "target": "", "id": 1888271, "action_name": "Alert triggered", "url": "https://weblate.osgeo.org/api/changes/1888271/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100758/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:23:30.577805Z", "action": 2, "target": "`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: 指定した部分文字列の位置を示す整数を返す PostgreSQL 文字列関数。", "id": 1487405, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1487405/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100758/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:23:03.884641Z", "action": 7, "target": "`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: 指定した部分文字列の位置を示す整数を返す PostgreSQL 文字列関数", "id": 1487404, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487404/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100756/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:58.828517Z", "action": 7, "target": "`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: 小数点以下の桁数を s 桁に丸めるPostgreSQL 数学関数", "id": 1487403, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487403/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100751/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:57.152962Z", "action": 7, "target": "`ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: ジオメトリと他のジオメトリとの距離が指定した距離以内である場合に TRUE を返します。", "id": 1487402, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487402/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100749/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:54.994907Z", "action": 7, "target": "`ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_: Bの点がAの外部に全く存在せず、Bの内部の少なくとも一つの点がAの内部に存在する場合にのみ TRUE を返します。", "id": 1487401, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487401/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100745/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:52.613021Z", "action": 7, "target": "前のように、結合で、\"JOIN ON\" 制約に合致した全てのありえる組合せの仮想テーブルが生成され、これらの行は \"GROUP\" による集約に渡されます。``ST_DWithin`` 関数が空間処理のミソで、適切な地下鉄駅に近い統計区だけを計算に取り込むようにします。", "id": 1487399, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487399/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100743/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:49.123050Z", "action": 7, "target": "これで地下鉄路線のテーブルを元のクエリに結合できます。", "id": 1487398, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487398/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100741/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:47.366389Z", "action": 7, "target": "その問に答えるには、これまでのクエリに他の結合を追加して、多数の地下鉄路線の構成を一括して同時に計算できるようにします。これを行うには、要約したい路線の全てを列挙する新しいテーブルを生成する必要があります。", "id": 1487397, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487397/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100739/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:45.757278Z", "action": 7, "target": "最後のセクションでは、A列車 が市の残りの領域の人種構成から大きく異なって人口に影響を与えるようなことがなかったことが分かりました。平均的でない人種構成を持つ列車はあるでしょうか?", "id": 1487396, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487396/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100736/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:43.660922Z", "action": 7, "target": "高度な結合", "id": 1487395, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487395/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100734/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:42.010630Z", "action": 7, "target": "A系統 に沿った人種構成はニューヨーク市全体の人種構成と根本的に違いはありません。", "id": 1487394, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487394/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100732/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:40.257825Z", "action": 7, "target": "A系統 の200メートル内の人種構成を要約しましょう。", "id": 1487393, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487393/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100730/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:37.997174Z", "action": 7, "target": "よって A列車 を見つけるには、``routes`` 内の 'A' を含む全ての行が必要です。これは様々な方法がありますが、今回は ``routes`` フィールド内に 'A' がある場合にだけ :command:`strpos(routes,'A')` が 0 以外の値を返すのを使います。", "id": 1487392, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487392/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100728/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:22:33.749714Z", "action": 7, "target": "``DISTINCT`` キーワードは結果から重複する行を削除します。``DISTINCT`` を使わない場合には、クエリの結果は 73件 でなく 491件 となります。", "id": 1487391, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487391/?format=api" } ] }