This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5936 | 5936 | 940ef | 1127 1127 |
| 6196 | 6196 | 940ef | 1128 1128 |
| 8182 | 8182 | 940ef | 1107 1107 |
| 14550 | 14550 | 940ef | 1612 1612 |
| 15128 | 15128 | 940ef | 1613 1613 |
| 30549 | 30549 | 940ef | 707 707 |
| 30580 | 30580 | 940ef | 706 706 |
| 30888 | 30888 | 940ef | 716 716 |
| 34510 | 34510 | 940ef | 704 704 |
| 34635 | 34635 | 940ef | 705 705 |
| 35183 | 35183 | 940ef | 715 715 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)