albums_labels

6 rows where label_id = 1243

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3388 3388 2962 2962 MCA Nashville  1243
6272 6272 5460 5460 MCA Nashville  1243
29401 29401 26510 26510 MCA Nashville  1243
29403 29403 26511 26511 MCA Nashville  1243
29405 29405 26512 26512 MCA Nashville  1243
30411 30411 27402 27402 MCA Nashville  1243

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