albums_labels

13 rows where label_id = 3866

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19750 19750 17595 17595 Castle 3866
21473 21473 19144 19144 Castle 3866
21563 21563 19226 19226 Castle 3866
21736 21736 19384 19384 Castle 3866
22461 22461 20045 20045 Castle 3866
23241 23241 20771 20771 Castle 3866
24222 24222 21693 21693 Castle 3866
25271 25271 22696 22696 Castle 3866
26290 26290 23666 23666 Castle 3866
26394 26394 23770 23770 Castle 3866
26851 26851 24204 24204 Castle 3866
27173 27173 24498 24498 Castle 3866
27691 27691 24982 24982 Castle 3866

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)
);