home / pf

albums_labels

5 rows where label_id = 954

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2324 2324 2023 2023 Method 954
4608 4608 4021 4021 Method 954
5586 5586 4864 4864 Method 954
11986 11986 10492 10492 Method 954
29356 29356 26472 26472 Method 954

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