albums_labels

7 rows where label_id = 483

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
863 863 736 736 Blackened 483
1592 1592 1383 1383 Blackened 483
2842 2842 2478 2478 Blackened 483
5352 5352 4661 4661 Blackened 483
6732 6732 5864 5864 Blackened 483
8254 8254 7192 7192 Blackened 483
29475 29475 26573 26573 Blackened 483

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