home / pf

albums_labels

7 rows where label_id = 1192

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3193 3193 2792 2792 Record Makers 1192
11788 11788 10320 10320 Record Makers 1192
12560 12560 11020 11020 Record Makers 1192
14463 14463 12774 12774 Record Makers 1192
19984 19984 17811 17811 Record Makers 1192
21336 21336 19022 19022 Record Makers 1192
27923 27923 25196 25196 Record Makers 1192

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);
Powered by Datasette · Queries took 68.498ms