albums_labels

10 rows where label_id = 469

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
829 829 702 702 Infectious 469
1883 1883 1646 1646 Infectious 469
3092 3092 2704 2704 Infectious 469
4139 4139 3624 3624 Infectious 469
9567 9567 8364 8364 Infectious 469
11256 11256 9848 9848 Infectious 469
11398 11398 9970 9970 Infectious 469
11603 11603 10153 10153 Infectious 469
13119 13119 11531 11531 Infectious 469
13665 13665 12035 12035 Infectious 469

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