home / pf

albums_labels

14 rows where label_id = 4113

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21251 21251 18941 18941 TVT 4113
22529 22529 20105 20105 TVT 4113
23231 23231 20761 20761 TVT 4113
23903 23903 21394 21394 TVT 4113
24178 24178 21651 21651 TVT 4113
26205 26205 23587 23587 TVT 4113
28430 28430 25663 25663 TVT 4113
28735 28735 25938 25938 TVT 4113
28805 28805 26001 26001 TVT 4113
28899 28899 26085 26085 TVT 4113
29044 29044 26208 26208 TVT 4113
29136 29136 26283 26283 TVT 4113
29273 29273 26401 26401 TVT 4113
29598 29598 26683 26683 TVT 4113

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