albums_labels

5 rows where label_id = 4275

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22362 22362 19954 19954 Profile 4275
23604 23604 21114 21114 Profile 4275
23605 23605 21115 21115 Profile 4275
23606 23606 21116 21116 Profile 4275
23607 23607 21117 21117 Profile 4275

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