albums_labels

18 rows where label_id = 426

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
729 729 617 617 Because 426
2327 2327 2024 2024 Because 426
3684 3684 3215 3215 Because 426
6780 6780 5908 5908 Because 426
12170 12170 10656 10656 Because 426
14178 14178 12504 12504 Because 426
15166 15166 13396 13396 Because 426
15627 15627 13802 13802 Because 426
15696 15696 13856 13856 Because 426
16082 16082 14199 14199 Because 426
17780 17780 15718 15718 Because 426
19281 19281 17133 17133 Because 426
19293 19293 17145 17145 Because 426
21278 21278 18966 18966 Because 426
21571 21571 19232 19232 Because 426
21807 21807 19446 19446 Because 426
22273 22273 19873 19873 Because 426
30339 30339 27338 27338 Because 426

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