albums_labels

5 rows where label_id = 2354

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8927 8927 7794 7794 Magic Bullet 2354
10222 10222 8945 8945 Magic Bullet 2354
10922 10922 9558 9558 Magic Bullet 2354
13066 13066 11481 11481 Magic Bullet 2354
22366 22366 19958 19958 Magic Bullet 2354

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