This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1053 | 1053 | ec3ac | 3194 3194 |
| 1054 | 1054 | 7b150 | 3194 3194 |
| 1055 | 1055 | e6200 | 3194 3194 |
| 1056 | 1056 | 3502d | 3194 3194 |
| 1057 | 1057 | b1201 | 3194 3194 |
| 1058 | 1058 | 8a7ee | 3194 3194 |
| 1059 | 1059 | 862ed | 3194 3194 |
| 1060 | 1060 | 6ec75 | 3194 3194 |
| 1061 | 1061 | 91693 | 3194 3194 |
| 1062 | 1062 | 1d2ab | 3194 3194 |
| 1063 | 1063 | 77d7e | 3194 3194 |
| 1064 | 1064 | abb72 | 3194 3194 |
| 1065 | 1065 | 27369 | 3194 3194 |
| 1066 | 1066 | e128e | 3194 3194 |
| 1067 | 1067 | feaa7 | 3194 3194 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)