albums_labels

11 rows where label_id = 2487

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9796 9796 8570 8570 Turnstile 2487
10439 10439 9134 9134 Turnstile 2487
10499 10499 9188 9188 Turnstile 2487
11067 11067 9686 9686 Turnstile 2487
11375 11375 9950 9950 Turnstile 2487
11899 11899 10413 10413 Turnstile 2487
12525 12525 10988 10988 Turnstile 2487
13715 13715 12081 12081 Turnstile 2487
16325 16325 14417 14417 Turnstile 2487
17053 17053 15069 15069 Turnstile 2487
24827 24827 22264 22264 Turnstile 2487

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