albums_labels

5 rows where label_id = 1185

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3139 3139 2744 2744 Beyond Beyond is Beyond 1185
3606 3606 3145 3145 Beyond Beyond is Beyond 1185
4342 4342 3792 3792 Beyond Beyond is Beyond 1185
4536 4536 3960 3960 Beyond Beyond is Beyond 1185
4790 4790 4183 4183 Beyond Beyond is Beyond 1185

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