albums_labels

10 rows where label_id = 3017

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13529 13529 11912 11912 Marriage 3017
15950 15950 14081 14081 Marriage 3017
18850 18850 16714 16714 Marriage 3017
19096 19096 16949 16949 Marriage 3017
19655 19655 17502 17502 Marriage 3017
20639 20639 18388 18388 Marriage 3017
21141 21141 18844 18844 Marriage 3017
21461 21461 19134 19134 Marriage 3017
21507 21507 19172 19172 Marriage 3017
22343 22343 19938 19938 Marriage 3017

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