albums_labels

10 rows where label_id = 4550

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24739 24739 22179 22179 Dreamworks 4550
25891 25891 23289 23289 Dreamworks 4550
26514 26514 23884 23884 Dreamworks 4550
27291 27291 24606 24606 Dreamworks 4550
27574 27574 24873 24873 Dreamworks 4550
28219 28219 25464 25464 Dreamworks 4550
28300 28300 25540 25540 Dreamworks 4550
28803 28803 25999 25999 Dreamworks 4550
29012 29012 26186 26186 Dreamworks 4550
29804 29804 26860 26860 Dreamworks 4550

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