This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18399 | 18399 | cc5ed | 2187 2187 |
| 18400 | 18400 | 371f0 | 2187 2187 |
| 18401 | 18401 | e6200 | 2187 2187 |
| 18402 | 18402 | b1201 | 2187 2187 |
| 18403 | 18403 | 8a7ee | 2187 2187 |
| 18404 | 18404 | 862ed | 2187 2187 |
| 18405 | 18405 | a2d21 | 2187 2187 |
| 18406 | 18406 | a1307 | 2187 2187 |
| 18407 | 18407 | abb72 | 2187 2187 |
| 18408 | 18408 | 27369 | 2187 2187 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)