albums_labels

7 rows where label_id = 1456

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4309 4309 3762 3762 Rabid 1456
6858 6858 5977 5977 Rabid 1456
11734 11734 10269 10269 Rabid 1456
13386 13386 11779 11779 Rabid 1456
16522 16522 14590 14590 Rabid 1456
18918 18918 16772 16772 Rabid 1456
23108 23108 20640 20640 Rabid 1456

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