home / pf

albums_labels

16 rows where label_id = 124

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
144 144 122 122 New Amsterdam 124
1314 1314 1129 1129 New Amsterdam 124
1465 1465 1271 1271 New Amsterdam 124
2067 2067 1800 1800 New Amsterdam 124
3020 3020 2642 2642 New Amsterdam 124
3189 3189 2788 2788 New Amsterdam 124
3615 3615 3152 3152 New Amsterdam 124
3973 3973 3472 3472 New Amsterdam 124
4733 4733 4131 4131 New Amsterdam 124
11357 11357 9936 9936 New Amsterdam 124
11961 11961 10468 10468 New Amsterdam 124
13039 13039 11454 11454 New Amsterdam 124
13420 13420 11813 11813 New Amsterdam 124
13808 13808 12165 12165 New Amsterdam 124
15182 15182 13412 13412 New Amsterdam 124
29474 29474 26572 26572 New Amsterdam 124

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