labels_pull_requests
4 rows where pull_requests_id = 709187466
This data as json, CSV (advanced)
| Link | labels_id | pull_requests_id |
|---|---|---|
| 119035353,709187466 | topic-internals 119035353 | Explicit indexes 709187466 |
| 135761084,709187466 | topic-indexing 135761084 | Explicit indexes 709187466 |
| 2223478915,709187466 | grant-czi 2223478915 | Explicit indexes 709187466 |
| 3419806739,709187466 | run-benchmark 3419806739 | Explicit indexes 709187466 |
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]);