albums_labels

23 rows where label_id = 316

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
499 499 421 421 Aftermath 316
797 797 672 672 Aftermath 316
1368 1368 1179 1179 Aftermath 316
3689 3689 3217 3217 Aftermath 316
5296 5296 4614 4614 Aftermath 316
5616 5616 4889 4889 Aftermath 316
6216 6216 5412 5412 Aftermath 316
6491 6491 5647 5647 Aftermath 316
6661 6661 5797 5797 Aftermath 316
7684 7684 6691 6691 Aftermath 316
10174 10174 8901 8901 Aftermath 316
10755 10755 9411 9411 Aftermath 316
12569 12569 11026 11026 Aftermath 316
13986 13986 12326 12326 Aftermath 316
17201 17201 15201 15201 Aftermath 316
18659 18659 16542 16542 Aftermath 316
20932 20932 18649 18649 Aftermath 316
22550 22550 20124 20124 Aftermath 316
24399 24399 21860 21860 Aftermath 316
24584 24584 22034 22034 Aftermath 316
24754 24754 22191 22191 Aftermath 316
25958 25958 23351 23351 Aftermath 316
26783 26783 24142 24142 Aftermath 316

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