albums_labels

10 rows where label_id = 679

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1414 1414 1222 1222 Trouble in Mind 679
2541 2541 2213 2213 Trouble in Mind 679
3290 3290 2877 2877 Trouble in Mind 679
4032 4032 3529 3529 Trouble in Mind 679
4609 4609 4022 4022 Trouble in Mind 679
4802 4802 4194 4194 Trouble in Mind 679
29240 29240 26372 26372 Trouble in Mind 679
30105 30105 27126 27126 Trouble in Mind 679
30202 30202 27215 27215 Trouble in Mind 679
30210 30210 27223 27223 Trouble in Mind 679

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