This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11293 | 11293 | 3896c | 897 897 |
| 11386 | 11386 | 3896c | 837 837 |
| 15298 | 15298 | 3896c | 869 869 |
| 31593 | 31593 | 3896c | 832 832 |
| 33449 | 33449 | 3896c | 921 921 |
| 33675 | 33675 | 3896c | 918 918 |
| 33704 | 33704 | 3896c | 922 922 |
| 33749 | 33749 | 3896c | 923 923 |
| 33991 | 33991 | 3896c | 911 911 |
| 34010 | 34010 | 3896c | 915 915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)