nielsen_medias

10 rows where medimach_code = 63

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ code title medimach_code
73 506700 AUTO MOT.SP. SAMS 63
74 1 AUTO MOT.SP.ACN1 SAMS 63
75 5 AUTO MOT.SP.ACN2 SAMS 63
76 970348 AUTO MOT.SP.ACN2+3B SAMS 63
77 970328 AUTO MOT.SP.ACN3 SAMS 63
78 31 AUTO MOT.SP.ACN3B SAMS 63
79 32 AUTO MOT.SP.ACN4 SAMS 63
80 970224 AUTO MOT.SP.ACN4+5+6+7 SAMS 63
81 33 AUTO MOT.SP.ACN5 SAMS 63
82 29 AUTO MOTOR UND SP. ACN_3A SAMS 63

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);