This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17046 | 17046 | ec3ac | 3379 3379 |
| 17047 | 17047 | e5946 | 3379 3379 |
| 17048 | 17048 | 7539c | 3379 3379 |
| 17049 | 17049 | 59d75 | 3379 3379 |
| 17050 | 17050 | e6200 | 3379 3379 |
| 17051 | 17051 | b1201 | 3379 3379 |
| 17052 | 17052 | 902e5 | 3379 3379 |
| 17053 | 17053 | 75bd7 | 3379 3379 |
| 17054 | 17054 | a0884 | 3379 3379 |
| 17055 | 17055 | 3b32c | 3379 3379 |
| 17056 | 17056 | 73272 | 3379 3379 |
| 17057 | 17057 | 6f82c | 3379 3379 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)