albums_labels

7 rows where label_id = 2346

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8889 8889 7760 7760 Free Bandz 2346
9496 9496 8303 8303 Free Bandz 2346
9591 9591 8387 8387 Free Bandz 2346
10260 10260 8976 8976 Free Bandz 2346
11992 11992 10496 10496 Free Bandz 2346
13671 13671 12040 12040 Free Bandz 2346
14664 14664 12952 12952 Free Bandz 2346

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