albums_labels

7 rows where label_id = 205

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
287 287 249 249 Iron Works 205
288 288 250 250 Iron Works 205
1655 1655 1439 1439 Iron Works 205
3251 3251 2844 2844 Iron Works 205
8673 8673 7563 7563 Iron Works 205
12947 12947 11372 11372 Iron Works 205
14781 14781 13053 13053 Iron Works 205

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