albums_labels

13 rows where label_id = 577

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1103 1103 947 947 Italians Do It Better 577
4035 4035 3532 3532 Italians Do It Better 577
6027 6027 5254 5254 Italians Do It Better 577
8443 8443 7356 7356 Italians Do It Better 577
10618 10618 9293 9293 Italians Do It Better 577
13178 13178 11586 11586 Italians Do It Better 577
14773 14773 13047 13047 Italians Do It Better 577
15128 15128 13362 13362 Italians Do It Better 577
15686 15686 13848 13848 Italians Do It Better 577
19103 19103 16956 16956 Italians Do It Better 577
20598 20598 18353 18353 Italians Do It Better 577
20809 20809 18538 18538 Italians Do It Better 577
21234 21234 18926 18926 Italians Do It Better 577

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