albums_labels

9 rows where label_id = 4295

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22483 22483 20064 20064 Recordhead 4295
23309 23309 20836 20836 Recordhead 4295
23310 23310 20837 20837 Recordhead 4295
23896 23896 21388 21388 Recordhead 4295
27156 27156 24483 24483 Recordhead 4295
27751 27751 25038 25038 Recordhead 4295
27760 27760 25045 25045 Recordhead 4295
28040 28040 25305 25305 Recordhead 4295
28199 28199 25446 25446 Recordhead 4295

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