albums_labels

7 rows where label_id = 4123

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21301 21301 18988 18988 Rawkus 4123
22003 22003 19627 19627 Rawkus 4123
24915 24915 22351 22351 Rawkus 4123
27012 27012 24353 24353 Rawkus 4123
27430 27430 24738 24738 Rawkus 4123
28577 28577 25794 25794 Rawkus 4123
28937 28937 26116 26116 Rawkus 4123

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