albums_labels

8 rows where label_id = 1402

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4019 4019 3517 3517 Alpha Pup 1402
10621 10621 9296 9296 Alpha Pup 1402
12965 12965 11389 11389 Alpha Pup 1402
15820 15820 13967 13967 Alpha Pup 1402
16924 16924 14948 14948 Alpha Pup 1402
18462 18462 16362 16362 Alpha Pup 1402
19310 19310 17162 17162 Alpha Pup 1402
20427 20427 18192 18192 Alpha Pup 1402

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