This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8081 | 8081 | ec3ac | 1052 1052 |
| 8082 | 8082 | 17183 | 1052 1052 |
| 8083 | 8083 | 96bbd | 1052 1052 |
| 8084 | 8084 | 550f6 | 1052 1052 |
| 8085 | 8085 | 343d8 | 1052 1052 |
| 8086 | 8086 | e0460 | 1052 1052 |
| 8087 | 8087 | 02db8 | 1052 1052 |
| 8088 | 8088 | aabe0 | 1052 1052 |
| 8089 | 8089 | 3e5f6 | 1052 1052 |
| 8090 | 8090 | 87fac | 1052 1052 |
| 8091 | 8091 | 1073c | 1052 1052 |
| 8092 | 8092 | 4801f | 1052 1052 |
| 8093 | 8093 | 5e075 | 1052 1052 |
| 8094 | 8094 | 59d75 | 1052 1052 |
| 8095 | 8095 | e6200 | 1052 1052 |
| 8096 | 8096 | b1201 | 1052 1052 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)