albums_labels

20 rows where label_id = 238

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
354 354 303 303 Concord 238
1074 1074 919 919 Concord 238
1532 1532 1327 1327 Concord 238
2136 2136 1856 1856 Concord 238
2601 2601 2267 2267 Concord 238
2653 2653 2313 2313 Concord 238
3585 3585 3127 3127 Concord 238
4077 4077 3570 3570 Concord 238
5429 5429 4729 4729 Concord 238
6634 6634 5774 5774 Concord 238
7729 7729 6725 6725 Concord 238
8239 8239 7178 7178 Concord 238
8982 8982 7843 7843 Concord 238
9938 9938 8692 8692 Concord 238
9940 9940 8693 8693 Concord 238
12148 12148 10638 10638 Concord 238
15746 15746 13902 13902 Concord 238
15851 15851 13994 13994 Concord 238
15852 15852 13995 13995 Concord 238
29820 29820 26871 26871 Concord 238

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