albums_labels

17 rows where label_id = 265

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
403 403 343 343 Not Not Fun 265
1832 1832 1605 1605 Not Not Fun 265
3307 3307 2891 2891 Not Not Fun 265
11921 11921 10431 10431 Not Not Fun 265
12075 12075 10571 10571 Not Not Fun 265
12264 12264 10744 10744 Not Not Fun 265
12570 12570 11027 11027 Not Not Fun 265
13596 13596 11976 11976 Not Not Fun 265
14165 14165 12492 12492 Not Not Fun 265
14675 14675 12960 12960 Not Not Fun 265
15265 15265 13485 13485 Not Not Fun 265
15448 15448 13649 13649 Not Not Fun 265
16200 16200 14303 14303 Not Not Fun 265
17062 17062 15078 15078 Not Not Fun 265
17093 17093 15107 15107 Not Not Fun 265
17732 17732 15674 15674 Not Not Fun 265
19813 19813 17655 17655 Not Not Fun 265

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