This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12083 | 12083 | ec3ac | 1942 1942 |
| 12084 | 12084 | d1e7b | 1942 1942 |
| 12085 | 12085 | 3502d | 1942 1942 |
| 12086 | 12086 | 2fb4b | 1942 1942 |
| 12087 | 12087 | 0deae | 1942 1942 |
| 12088 | 12088 | 28197 | 1942 1942 |
| 12089 | 12089 | 5af7b | 1942 1942 |
| 12090 | 12090 | fb7e5 | 1942 1942 |
| 12091 | 12091 | 73536 | 1942 1942 |
| 12092 | 12092 | 0ee72 | 1942 1942 |
| 12093 | 12093 | 681cb | 1942 1942 |
| 12094 | 12094 | 1eefa | 1942 1942 |
| 12095 | 12095 | 2e7ac | 1942 1942 |
| 12096 | 12096 | fbd18 | 1942 1942 |
| 12097 | 12097 | 13f76 | 1942 1942 |
| 12098 | 12098 | 3f17e | 1942 1942 |
| 12099 | 12099 | 65b81 | 1942 1942 |
| 12100 | 12100 | 78e17 | 1942 1942 |
| 12101 | 12101 | dff8a | 1942 1942 |
| 12102 | 12102 | f6a31 | 1942 1942 |
| 12103 | 12103 | 29ba2 | 1942 1942 |
| 12104 | 12104 | df754 | 1942 1942 |
| 12105 | 12105 | ecdca | 1942 1942 |
| 12106 | 12106 | 81f6b | 1942 1942 |
| 12107 | 12107 | eca31 | 1942 1942 |
| 12108 | 12108 | 21427 | 1942 1942 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)