albums_labels

13 rows where label_id = 1610

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5020 5020 4386 4386 Tommy Boy 1610
5543 5543 4826 4826 Tommy Boy 1610
8457 8457 7370 7370 Tommy Boy 1610
8801 8801 7681 7681 Tommy Boy 1610
10102 10102 8840 8840 Tommy Boy 1610
11054 11054 9676 9676 Tommy Boy 1610
22651 22651 20216 20216 Tommy Boy 1610
24062 24062 21547 21547 Tommy Boy 1610
24638 24638 22084 22084 Tommy Boy 1610
25651 25651 23057 23057 Tommy Boy 1610
26280 26280 23658 23658 Tommy Boy 1610
27830 27830 25110 25110 Tommy Boy 1610
29325 29325 26448 26448 Tommy Boy 1610

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