albums_labels

16 rows where label_id = 299

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
466 466 396 396 Castle Face 299
2877 2877 2509 2509 Castle Face 299
3770 3770 3291 3291 Castle Face 299
4218 4218 3687 3687 Castle Face 299
10487 10487 9178 9178 Castle Face 299
10916 10916 9554 9554 Castle Face 299
10950 10950 9585 9585 Castle Face 299
11013 11013 9645 9645 Castle Face 299
11072 11072 9689 9689 Castle Face 299
11533 11533 10089 10089 Castle Face 299
11723 11723 10261 10261 Castle Face 299
11979 11979 10486 10486 Castle Face 299
12216 12216 10700 10700 Castle Face 299
12480 12480 10950 10950 Castle Face 299
12798 12798 11238 11238 Castle Face 299
13356 13356 11753 11753 Castle Face 299

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