albums_labels

19 rows where label_id = 674

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1399 1399 1208 1208 Craft 674
1475 1475 1277 1277 Craft 674
2948 2948 2574 2574 Craft 674
2949 2949 2575 2575 Craft 674
2950 2950 2576 2576 Craft 674
3377 3377 2952 2952 Craft 674
3858 3858 3371 3371 Craft 674
3863 3863 3376 3376 Craft 674
3953 3953 3454 3454 Craft 674
4043 4043 3540 3540 Craft 674
5365 5365 4671 4671 Craft 674
6465 6465 5625 5625 Craft 674
6792 6792 5920 5920 Craft 674
7026 7026 6116 6116 Craft 674
29323 29323 26446 26446 Craft 674
29333 29333 26456 26456 Craft 674
29722 29722 26787 26787 Craft 674
30133 30133 27153 27153 Craft 674
30415 30415 27406 27406 Craft 674

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