This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31457 | 31457 | f9e5c | 2421 2421 |
| 31473 | 31473 | f9e5c | 2437 2437 |
| 31533 | 31533 | f9e5c | 2436 2436 |
| 31907 | 31907 | f9e5c | 2411 2411 |
| 32049 | 32049 | f9e5c | 2423 2423 |
| 32083 | 32083 | f9e5c | 2419 2419 |
| 32089 | 32089 | f9e5c | 2412 2412 |
| 32112 | 32112 | f9e5c | 2413 2413 |
| 32139 | 32139 | f9e5c | 2417 2417 |
| 32371 | 32371 | f9e5c | 2428 2428 |
| 34577 | 34577 | f9e5c | 2435 2435 |
| 34782 | 34782 | f9e5c | 2434 2434 |
| 35190 | 35190 | f9e5c | 2418 2418 |
| 35252 | 35252 | f9e5c | 2414 2414 |
| 36685 | 36685 | f9e5c | 2425 2425 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)