home / pf

albums_labels

10 rows where label_id = 57

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
65 65 58 58 Sony Music Latin 57
168 168 144 144 Sony Music Latin 57
1042 1042 893 893 Sony Music Latin 57
1570 1570 1363 1363 Sony Music Latin 57
1794 1794 1566 1566 Sony Music Latin 57
2341 2341 2036 2036 Sony Music Latin 57
2850 2850 2486 2486 Sony Music Latin 57
3772 3772 3293 3293 Sony Music Latin 57
4736 4736 4133 4133 Sony Music Latin 57
29767 29767 26826 26826 Sony Music Latin 57

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