albums_labels

10 rows where label_id = 3144

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14552 14552 12853 12853 Acute 3144
17573 17573 15528 15528 Acute 3144
18926 18926 16780 16780 Acute 3144
19630 19630 17477 17477 Acute 3144
20698 20698 18442 18442 Acute 3144
22220 22220 19827 19827 Acute 3144
24497 24497 21956 21956 Acute 3144
24498 24498 21957 21957 Acute 3144
26425 26425 23798 23798 Acute 3144
26643 26643 24010 24010 Acute 3144

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