albums_labels

6 rows where label_id = 3788

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19360 19360 17212 17212 Blocks 3788
19361 19361 17213 17213 Blocks 3788
22782 22782 20338 20338 Blocks 3788
23037 23037 20574 20574 Blocks 3788
24211 24211 21683 21683 Blocks 3788
24444 24444 21905 21905 Blocks 3788

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