albums_labels

6 rows where label_id = 465

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
817 817 691 691 Generation Now 465
3467 3467 3030 3030 Generation Now 465
3508 3508 3065 3065 Generation Now 465
4092 4092 3585 3585 Generation Now 465
29534 29534 26628 26628 Generation Now 465
29744 29744 26806 26806 Generation Now 465

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