This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21349 | 21349 | b4bbb | 2898 2898 |
| 21373 | 21373 | b4bbb | 2951 2951 |
| 21675 | 21675 | b4bbb | 2952 2952 |
| 22242 | 22242 | b4bbb | 2954 2954 |
| 23007 | 23007 | b4bbb | 2953 2953 |
| 23706 | 23706 | b4bbb | 2915 2915 |
| 24067 | 24067 | b4bbb | 2916 2916 |
| 24189 | 24189 | b4bbb | 2899 2899 |
| 24975 | 24975 | b4bbb | 2914 2914 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)