albums_labels

4 rows where label_id = 2789

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11879 11879 10396 10396 Peoples Potential Unlimited 2789
12152 12152 10642 10642 Peoples Potential Unlimited 2789
13577 13577 11957 11957 Peoples Potential Unlimited 2789
17162 17162 15170 15170 Peoples Potential Unlimited 2789

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