38 rows
where spotset_id = 35
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
spotset_id
|
media_id
|
| 35,BB_0_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Classic Gesamt BB_0_000 |
| 35,BB_1_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Classic Departure BB_1_000 |
| 35,BB_2_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Classic Arrival BB_2_000 |
| 35,BB_3_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Classic Sicherheitsbereich BB_3_000 |
| 35,BB_4_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Classic Öffentlicher Bereich BB_4_000 |
| 35,BB_5_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Düsseldorf Sicherheitsbereich BB_5_000 |
| 35,BB_6_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Düsseldorf Departure BB_6_000 |
| 35,BB_7_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Düsseldorf Arrival BB_7_000 |
| 35,BC_0_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hamburg Gesamt BC_0_000 |
| 35,BC_1_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hamburg Sicherheitsbereich BC_1_000 |
| 35,BC_2_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hamburg Öffentlicher Bereich BC_2_000 |
| 35,BC_3_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hamburg Departure BC_3_000 |
| 35,BC_4_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hamburg Arrival BC_4_000 |
| 35,BD_0_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hannover Gesamt BD_0_000 |
| 35,BD_1_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hannover Sicherheitsbereich BD_1_000 |
| 35,BD_2_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hannover Öffentlicher Bereich BD_2_000 |
| 35,BD_3_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hannover Departure BD_3_000 |
| 35,BD_4_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Hannover Arrival BD_4_000 |
| 35,BE_0_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint München Gesamt BE_0_000 |
| 35,BE_1_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint München Sicherheitsbereich BE_1_000 |
| 35,BE_2_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint München Öffentlicher Bereich BE_2_000 |
| 35,BE_3_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint München Departure BE_3_000 |
| 35,BE_4_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint München Arrival BE_4_000 |
| 35,BF_0_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Nürnberg Gesamt BF_0_000 |
| 35,BF_1_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Nürnberg Sicherheitsbereich BF_1_000 |
| 35,BF_2_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Nürnberg Öffentlicher Bereich BF_2_000 |
| 35,BF_3_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Nürnberg Departure BF_3_000 |
| 35,BF_4_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Nürnberg Arrival BF_4_000 |
| 35,BG_0_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Stuttgart Gesamt BG_0_000 |
| 35,BG_1_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Stuttgart Sicherheitsbereich BG_1_000 |
| 35,BG_2_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Stuttgart Öffentlicher Bereich BG_2_000 |
| 35,BG_3_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Stuttgart Departure BG_3_000 |
| 35,BG_4_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Stuttgart Arrival BG_4_000 |
| 35,BH_0_000 |
CITTADINO GmbH (5) 35 |
Airport Touchpoint Dresden BH_0_000 |
| 35,BI_1_000 |
CITTADINO GmbH (5) 35 |
Autobahn Touchpoint Classic Gesamt BI_1_000 |
| 35,BI_2_000 |
CITTADINO GmbH (5) 35 |
Autobahn Touchpoint Classic Kasse BI_2_000 |
| 35,BI_3_000 |
CITTADINO GmbH (5) 35 |
Autobahn Touchpoint Classic Kühltheke BI_3_000 |
| 35,BI_4_000 |
CITTADINO GmbH (5) 35 |
Autobahn Touchpoint Classic Gondel BI_4_000 |
CREATE TABLE spotset_medias (
spotset_id INTEGER NOT NULL,
media_id VARCHAR(8) NOT NULL,
PRIMARY KEY (spotset_id, media_id),
FOREIGN KEY(spotset_id) REFERENCES spotset (id),
FOREIGN KEY(media_id) REFERENCES media (id)
);