albums_labels

6 rows where label_id = 1379

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3923 3923 3428 3428 VP 1379
13310 13310 11714 11714 VP 1379
16360 16360 14447 14447 VP 1379
20984 20984 18698 18698 VP 1379
23996 23996 21483 21483 VP 1379
25856 25856 23255 23255 VP 1379

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