nielsen_medias

10 rows where medimach_code = 24

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ code title medimach_code
24 500900 ADAC MOTORWELT SADA 24
25 106 ADAC MOTORWELT ACN 1 SADA 24
26 107 ADAC MOTORWELT ACN 2 SADA 24
27 970635 ADAC MOTORWELT ACN 3 SADA 24
28 108 ADAC MOTORWELT ACN 3A SADA 24
29 109 ADAC MOTORWELT ACN 3B SADA 24
30 110 ADAC MOTORWELT ACN 4 SADA 24
31 970777 ADAC MOTORWELT ACN 4-7 SADA 24
32 179 ADAC MOTORWELT ACN 5+6+7 SADA 24
33 970551 ADAC MOTORWELT ACN_12 SADA 24

Advanced export

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

CSV options: 

CREATE TABLE nielsen_medias (
	id INTEGER NOT NULL, 
	code VARCHAR(100), 
	title VARCHAR(250), 
	medimach_code INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(medimach_code) REFERENCES medimach_codes (id)
);
CREATE UNIQUE INDEX ix_nielsen_medias_code ON nielsen_medias (code);
CREATE INDEX ix_nielsen_medias_medimach_code ON nielsen_medias (medimach_code);