albums_labels

12 rows where label_id = 1020

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2508 2508 2187 2187 Border Community 1020
6820 6820 5946 5946 Border Community 1020
9446 9446 8260 8260 Border Community 1020
11685 11685 10230 10230 Border Community 1020
13049 13049 11465 11465 Border Community 1020
14199 14199 12524 12524 Border Community 1020
15153 15153 13384 13384 Border Community 1020
16792 16792 14829 14829 Border Community 1020
18377 18377 16282 16282 Border Community 1020
20363 20363 18134 18134 Border Community 1020
23068 23068 20605 20605 Border Community 1020
29454 29454 26554 26554 Border Community 1020

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