albums_labels

12 rows where label_id = 145

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
177 177 153 153 Swami 145
19706 19706 17552 17552 Swami 145
20274 20274 18054 18054 Swami 145
22341 22341 19936 19936 Swami 145
22784 22784 20340 20340 Swami 145
24142 24142 21620 21620 Swami 145
24170 24170 21643 21643 Swami 145
24903 24903 22339 22339 Swami 145
25010 25010 22446 22446 Swami 145
25812 25812 23216 23216 Swami 145
27455 27455 24761 24761 Swami 145
28768 28768 25967 25967 Swami 145

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