building

13 rows where publisher = 11

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name_publisher publisher
BK-11711 Burger King, Hamburg, Steilshooper Allee 55 Piranha Media GmbH  11
BK-11946 Burger King, Hamburg, Stader Strasse 302 Piranha Media GmbH  11
BK-12532 Burger King, Hamburg, Hahenkamp 1 Piranha Media GmbH  11
BK-13383 Burger King, Hamburg, Reinbeker Redder 2 Piranha Media GmbH  11
BK-14155 Burger King, Hamburg, Osdorfer Landstrasse 25 Piranha Media GmbH  11
BK-15226 Burger King, Hamburg, Julius-Brecht-Strasse 6 Piranha Media GmbH  11
BK-15297 Burger King, Hamburg, Berner Heerweg 175 Piranha Media GmbH  11
BK-16206 Burger King, Hamburg, Alsterkrugchaussee 337-339 Piranha Media GmbH  11
BK-16593 Burger King, Hamburg, Langenhorner Chaussee 471 Piranha Media GmbH  11
BK-21942 Burger King, Hamburg, Mundsburger Damm 67 Piranha Media GmbH  11
BK-22119 Burger King, Hamburg, Friedrich-Ebert-Damm 166 Piranha Media GmbH  11
BK-6161 Burger King, Hamburg, Kieler Strasse 222 Piranha Media GmbH  11
BK-7158 Burger King, Hamburg, Reeperbahn 75 Piranha Media GmbH  11

Advanced export

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

CSV options: 

CREATE TABLE building (
	id VARCHAR(100) NOT NULL, 
	name_publisher VARCHAR(250), 
	publisher INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE INDEX ix_building_name_publisher ON building (name_publisher);
CREATE INDEX ix_building_publisher ON building (publisher);