home / pf

albums_labels

13 rows where label_id = 1560

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4810 4810 4201 4201 Accidental 1560
10962 10962 9597 9597 Accidental 1560
11666 11666 10212 10212 Accidental 1560
13068 13068 11483 11483 Accidental 1560
13756 13756 12120 12120 Accidental 1560
15384 15384 13593 13593 Accidental 1560
16874 16874 14906 14906 Accidental 1560
17486 17486 15451 15451 Accidental 1560
23803 23803 21299 21299 Accidental 1560
24004 24004 21491 21491 Accidental 1560
24790 24790 22227 22227 Accidental 1560
25255 25255 22681 22681 Accidental 1560
26232 26232 23613 23613 Accidental 1560

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