albums_labels

22 rows where label_id = 3748

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19122 19122 16975 16975 Kindercore 3748
22991 22991 20533 20533 Kindercore 3748
22992 22992 20534 20534 Kindercore 3748
22993 22993 20535 20535 Kindercore 3748
27022 27022 24362 24362 Kindercore 3748
27158 27158 24485 24485 Kindercore 3748
27378 27378 24690 24690 Kindercore 3748
27585 27585 24884 24884 Kindercore 3748
27868 27868 25144 25144 Kindercore 3748
27895 27895 25170 25170 Kindercore 3748
28313 28313 25553 25553 Kindercore 3748
28360 28360 25598 25598 Kindercore 3748
28452 28452 25684 25684 Kindercore 3748
28467 28467 25695 25695 Kindercore 3748
28469 28469 25697 25697 Kindercore 3748
28485 28485 25713 25713 Kindercore 3748
28657 28657 25866 25866 Kindercore 3748
28700 28700 25905 25905 Kindercore 3748
28732 28732 25935 25935 Kindercore 3748
28818 28818 26014 26014 Kindercore 3748
28921 28921 26104 26104 Kindercore 3748
28983 28983 26160 26160 Kindercore 3748

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