albums_labels

4 rows where label_id = 3336

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15973 15973 14101 14101 Alien Transistor 3336
17796 17796 15733 15733 Alien Transistor 3336
24147 24147 21623 21623 Alien Transistor 3336
26154 26154 23539 23539 Alien Transistor 3336

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