albums_labels

14 rows where label_id = 2294

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8586 8586 7489 7489 Philips 2294
8768 8768 7651 7651 Philips 2294
8769 8769 7652 7652 Philips 2294
8770 8770 7653 7653 Philips 2294
8771 8771 7654 7654 Philips 2294
8772 8772 7655 7655 Philips 2294
8773 8773 7656 7656 Philips 2294
8774 8774 7657 7657 Philips 2294
9961 9961 8709 8709 Philips 2294
19644 19644 17491 17491 Philips 2294
22555 22555 20129 20129 Philips 2294
24833 24833 22270 22270 Philips 2294
26060 26060 23450 23450 Philips 2294
26061 26061 23451 23451 Philips 2294

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