home / pf

albums_labels

12 rows where label_id = 2832

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12176 12176 10662 10662 Greedhead 2832
12666 12666 11120 11120 Greedhead 2832
13506 13506 11894 11894 Greedhead 2832
13611 13611 11988 11988 Greedhead 2832
13856 13856 12211 12211 Greedhead 2832
14654 14654 12945 12945 Greedhead 2832
14665 14665 12953 12953 Greedhead 2832
14734 14734 13013 13013 Greedhead 2832
15052 15052 13291 13291 Greedhead 2832
15120 15120 13354 13354 Greedhead 2832
15501 15501 13696 13696 Greedhead 2832
17139 17139 15149 15149 Greedhead 2832

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)
);
Powered by Datasette · Queries took 46.648ms