albums_labels

5 rows where label_id = 2592

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10508 10508 9195 9195 Zoo Music 2592
11219 11219 9814 9814 Zoo Music 2592
11833 11833 10356 10356 Zoo Music 2592
12846 12846 11282 11282 Zoo Music 2592
13204 13204 11611 11611 Zoo Music 2592

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