home / pf

albums_labels

9 rows where label_id = 3136

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14496 14496 12803 12803 Upper Class 3136
16613 16613 14668 14668 Upper Class 3136
20477 20477 18241 18241 Upper Class 3136
22768 22768 20326 20326 Upper Class 3136
24127 24127 21605 21605 Upper Class 3136
25258 25258 22684 22684 Upper Class 3136
25353 25353 22776 22776 Upper Class 3136
25674 25674 23080 23080 Upper Class 3136
26452 26452 23823 23823 Upper Class 3136

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