home / pf

albums_labels

12 rows where label_id = 3274

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15574 15574 13756 13756 Universal Motown 3274
16593 16593 14655 14655 Universal Motown 3274
16817 16817 14852 14852 Universal Motown 3274
17219 17219 15216 15216 Universal Motown 3274
17411 17411 15381 15381 Universal Motown 3274
17752 17752 15692 15692 Universal Motown 3274
17858 17858 15792 15792 Universal Motown 3274
18163 18163 16080 16080 Universal Motown 3274
18766 18766 16642 16642 Universal Motown 3274
20565 20565 18323 18323 Universal Motown 3274
22241 22241 19847 19847 Universal Motown 3274
29529 29529 26623 26623 Universal Motown 3274

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)
);
Powered by Datasette · Queries took 61.115ms