home / pf

albums_labels

23 rows where label_id = 360

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
596 596 500 500 Thirty Tigers 360
761 761 644 644 Thirty Tigers 360
965 965 823 823 Thirty Tigers 360
1130 1130 971 971 Thirty Tigers 360
2039 2039 1776 1776 Thirty Tigers 360
2254 2254 1960 1960 Thirty Tigers 360
2295 2295 1997 1997 Thirty Tigers 360
2637 2637 2299 2299 Thirty Tigers 360
2935 2935 2562 2562 Thirty Tigers 360
3316 3316 2898 2898 Thirty Tigers 360
4722 4722 4121 4121 Thirty Tigers 360
5448 5448 4744 4744 Thirty Tigers 360
8651 8651 7542 7542 Thirty Tigers 360
9493 9493 8301 8301 Thirty Tigers 360
10045 10045 8786 8786 Thirty Tigers 360
10243 10243 8962 8962 Thirty Tigers 360
13021 13021 11440 11440 Thirty Tigers 360
14766 14766 13040 13040 Thirty Tigers 360
29316 29316 26439 26439 Thirty Tigers 360
29440 29440 26541 26541 Thirty Tigers 360
29655 29655 26731 26731 Thirty Tigers 360
29740 29740 26803 26803 Thirty Tigers 360
29945 29945 26981 26981 Thirty Tigers 360

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