home / pf

albums_labels

5 rows where label_id = 1026

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2527 2527 2202 2202 Marci 1026
5519 5519 4806 4806 Marci 1026
6393 6393 5564 5564 Marci 1026
7858 7858 6838 6838 Marci 1026
29628 29628 26707 26707 Marci 1026

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