labels_pull_requests
10 rows where pull_requests_id = 1501781892
This data as json, CSV (advanced)
| Link | labels_id | pull_requests_id |
|---|---|---|
| 114009210,1501781892 | topic-backends 114009210 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 135761084,1501781892 | topic-indexing 135761084 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 156998660,1501781892 | topic-CF conventions 156998660 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 235821884,1501781892 | topic-plotting 235821884 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 482927450,1501781892 | topic-testing 482927450 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 1106764573,1501781892 | topic-cftime 1106764573 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 1981132365,1501781892 | topic-html-repr 1981132365 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 2616288135,1501781892 | needs triage 2616288135 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 3152287510,1501781892 | topic-combine 3152287510 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
| 4429774983,1501781892 | io 4429774983 | [pre-commit.ci] pre-commit autoupdate 1501781892 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [labels_pull_requests] (
[labels_id] INTEGER REFERENCES [labels]([id]),
[pull_requests_id] INTEGER REFERENCES [pull_requests]([id]),
PRIMARY KEY ([labels_id], [pull_requests_id])
);
CREATE INDEX [idx_labels_pull_requests_pull_requests_id]
ON [labels_pull_requests] ([pull_requests_id]);
CREATE INDEX [idx_labels_pull_requests_labels_id]
ON [labels_pull_requests] ([labels_id]);