albums_labels

4 rows where label_id = 1356

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3847 3847 3361 3361 Martha's Music 1356
5279 5279 4603 4603 Martha's Music 1356
6874 6874 5990 5990 Martha's Music 1356
29567 29567 26656 26656 Martha's Music 1356

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