16 rows where spotset = 8

View and edit SQL

id ▼ spot_config spotset is_internal
721 355 355 8 8 1
722 528 528 8 8 1
723 529 529 8 8 1
724 530 530 8 8 1
725 531 531 8 8 1
726 532 532 8 8 1
727 533 533 8 8 1
728 534 534 8 8 1
729 535 535 8 8 1
730 536 536 8 8 1
731 537 537 8 8 1
732 538 538 8 8 1
733 539 539 8 8 1
734 540 540 8 8 1
735 541 541 8 8 1
736 542 542 8 8 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE gaia_spotconfig_in_spotsets (
	id INTEGER NOT NULL, 
	spot_config INTEGER, 
	spotset INTEGER, 
	is_internal BOOLEAN, 
	PRIMARY KEY (id), 
	FOREIGN KEY(spot_config) REFERENCES spot_config (config_id), 
	FOREIGN KEY(spotset) REFERENCES gaia_spotsets (spotset_id)
);