albums_labels

12 rows where label_id = 1602

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4974 4974 4344 4344 Trouble in Mind 1602
5456 5456 4752 4752 Trouble in Mind 1602
5788 5788 5040 5040 Trouble in Mind 1602
6977 6977 6073 6073 Trouble in Mind 1602
10100 10100 8838 8838 Trouble in Mind 1602
10205 10205 8930 8930 Trouble in Mind 1602
10289 10289 9002 9002 Trouble in Mind 1602
10804 10804 9455 9455 Trouble in Mind 1602
12332 12332 10809 10809 Trouble in Mind 1602
13617 13617 11992 11992 Trouble in Mind 1602
14270 14270 12594 12594 Trouble in Mind 1602
15483 15483 13680 13680 Trouble in Mind 1602

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