albums_labels

5 rows where label_id = 1198

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3216 3216 2813 2813 Ba Da Bing 1198
3662 3662 3194 3194 Ba Da Bing 1198
4770 4770 4165 4165 Ba Da Bing 1198
5574 5574 4852 4852 Ba Da Bing 1198
5694 5694 4956 4956 Ba Da Bing 1198

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