albums_labels

11 rows where label_id = 203

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
285 285 247 247 Dais 203
1081 1081 926 926 Dais 203
1390 1390 1200 1200 Dais 203
1597 1597 1387 1387 Dais 203
2514 2514 2192 2192 Dais 203
3366 3366 2942 2942 Dais 203
3921 3921 3426 3426 Dais 203
5378 5378 4683 4683 Dais 203
5774 5774 5026 5026 Dais 203
6432 6432 5598 5598 Dais 203
29892 29892 26934 26934 Dais 203

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