albums_labels

6 rows where label_id = 1175

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3112 3112 2719 2719 Westbound 1175
23807 23807 21303 21303 Westbound 1175
23808 23808 21304 21304 Westbound 1175
23809 23809 21305 21305 Westbound 1175
23810 23810 21306 21306 Westbound 1175
25673 25673 23079 23079 Westbound 1175

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