home / pf

albums_labels

11 rows where label_id = 4340

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22898 22898 20444 20444 Teenbeat 4340
24326 24326 21795 21795 Teenbeat 4340
25659 25659 23065 23065 Teenbeat 4340
26366 26366 23742 23742 Teenbeat 4340
26691 26691 24055 24055 Teenbeat 4340
26819 26819 24176 24176 Teenbeat 4340
26844 26844 24199 24199 Teenbeat 4340
27286 27286 24601 24601 Teenbeat 4340
27591 27591 24888 24888 Teenbeat 4340
28911 28911 26097 26097 Teenbeat 4340
28914 28914 26099 26099 Teenbeat 4340

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 57.223ms