albums_labels

12 rows where label_id = 227

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
337 337 290 290 XO 227
1233 1233 1064 1064 XO 227
3246 3246 2840 2840 XO 227
3454 3454 3019 3019 XO 227
4829 4829 4219 4219 XO 227
6036 6036 5261 5261 XO 227
6268 6268 5458 5458 XO 227
7256 7256 6311 6311 XO 227
8226 8226 7168 7168 XO 227
10111 10111 8846 8846 XO 227
12790 12790 11231 11231 XO 227
29734 29734 26799 26799 XO 227

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