nielsen_medias
4 rows where medimach_code = 68
This data as json, CSV (advanced)
| id ▼ | code | title | medimach_code |
|---|---|---|---|
| 87 | 974820 | AUTOSCOUT23.DE | AGOF_INT10182 68 |
| 88 | 974807 | AUTOSCOUT24 ROTATION | AGOF_INT10182 68 |
| 89 | 972478 | AUTOSCOUT24.DE | AGOF_INT10182 68 |
| 90 | 973254 | AUTOSCOUT24.DE INTERACTIV | AGOF_INT10182 68 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);