spotset

15 rows where publisher = 12

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: extern

id ▼ name publisher extern
18 Ströer Ströer 12 1
19 Ströer (1) Ströer 12 1
20 Ströer (2) Ströer 12 1
21 Ströer (3) Ströer 12 1
22 Ströer (4) Ströer 12 1
23 Ströer (5) Ströer 12 1
24 Ströer (6) Ströer 12 1
25 Ströer (7) Ströer 12 1
58 Ströer (8) Ströer 12 0
59 Ströer (9) Ströer 12 0
60 Ströer (10) Ströer 12 0
61 Ströer (11) Ströer 12 0
62 Ströer (12) Ströer 12 0
63 Ströer (13) Ströer 12 0
64 Ströer (14) Ströer 12 0

Advanced export

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

CSV options: 

CREATE TABLE spotset (
	id INTEGER NOT NULL, 
	name VARCHAR(250), 
	publisher INTEGER, 
	extern BOOLEAN, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE UNIQUE INDEX ix_spotset_name ON spotset (name);
CREATE INDEX ix_spotset_extern ON spotset (extern);
CREATE INDEX ix_spotset_publisher ON spotset (publisher);