albums_labels

21 rows where label_id = 64

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
73 73 66 66 Year0001 64
268 268 232 232 Year0001 64
595 595 499 499 Year0001 64
999 999 853 853 Year0001 64
1309 1309 1124 1124 Year0001 64
1653 1653 1437 1437 Year0001 64
1905 1905 1664 1664 Year0001 64
1920 1920 1677 1677 Year0001 64
2138 2138 1858 1858 Year0001 64
2428 2428 2115 2115 Year0001 64
2979 2979 2605 2605 Year0001 64
3220 3220 2817 2817 Year0001 64
3360 3360 2936 2936 Year0001 64
3760 3760 3281 3281 Year0001 64
4081 4081 3574 3574 Year0001 64
4587 4587 4005 4005 Year0001 64
5067 5067 4428 4428 Year0001 64
5318 5318 4632 4632 Year0001 64
5513 5513 4800 4800 Year0001 64
6804 6804 5931 5931 Year0001 64
29284 29284 26412 26412 Year0001 64

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