albums_labels

5 rows where label_id = 1862

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6284 6284 5471 5471 Firehouse 12 1862
8324 8324 7257 7257 Firehouse 12 1862
8965 8965 7827 7827 Firehouse 12 1862
9310 9310 8140 8140 Firehouse 12 1862
10020 10020 8764 8764 Firehouse 12 1862

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