albums_labels

5 rows where label_id = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
462 462 392 392 Neon Gold 296
1870 1870 1636 1636 Neon Gold 296
9853 9853 8618 8618 Neon Gold 296
10630 10630 9303 9303 Neon Gold 296
11042 11042 9667 9667 Neon Gold 296

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