albums_labels

7 rows where label_id = 459

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
802 802 676 676 Rimas 459
2488 2488 2170 2170 Rimas 459
3237 3237 2832 2832 Rimas 459
3529 3529 3082 3082 Rimas 459
5141 5141 4497 4497 Rimas 459
29493 29493 26590 26590 Rimas 459
30043 30043 27071 27071 Rimas 459

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