albums_labels

8 rows where label_id = 93

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
107 107 95 95 Ruby Yacht 93
1329 1329 1143 1143 Ruby Yacht 93
3493 3493 3052 3052 Ruby Yacht 93
5701 5701 4962 4962 Ruby Yacht 93
6627 6627 5768 5768 Ruby Yacht 93
7214 7214 6278 6278 Ruby Yacht 93
9904 9904 8662 8662 Ruby Yacht 93
30080 30080 27102 27102 Ruby Yacht 93

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