albums_labels

20 rows where label_id = 3802

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19449 19449 17300 17300 Atavistic 3802
23089 23089 20625 20625 Atavistic 3802
23204 23204 20735 20735 Atavistic 3802
25050 25050 22486 22486 Atavistic 3802
26260 26260 23640 23640 Atavistic 3802
26478 26478 23848 23848 Atavistic 3802
26525 26525 23895 23895 Atavistic 3802
27024 27024 24364 24364 Atavistic 3802
27878 27878 25154 25154 Atavistic 3802
28217 28217 25463 25463 Atavistic 3802
28248 28248 25492 25492 Atavistic 3802
28339 28339 25578 25578 Atavistic 3802
28624 28624 25837 25837 Atavistic 3802
28658 28658 25867 25867 Atavistic 3802
28726 28726 25929 25929 Atavistic 3802
28754 28754 25954 25954 Atavistic 3802
28933 28933 26113 26113 Atavistic 3802
28934 28934 26114 26114 Atavistic 3802
29049 29049 26213 26213 Atavistic 3802
29053 29053 26216 26216 Atavistic 3802

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