albums_labels

13 rows where label_id = 1496

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4495 4495 3921 3921 Maverick 1496
5687 5687 4949 4949 Maverick 1496
7055 7055 6142 6142 Maverick 1496
7188 7188 6256 6256 Maverick 1496
23402 23402 20924 20924 Maverick 1496
24009 24009 21496 21496 Maverick 1496
25427 25427 22846 22846 Maverick 1496
26017 26017 23407 23407 Maverick 1496
26405 26405 23779 23779 Maverick 1496
27730 27730 25018 25018 Maverick 1496
28955 28955 26133 26133 Maverick 1496
29100 29100 26253 26253 Maverick 1496
29687 29687 26758 26758 Maverick 1496

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