This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28413 | 28413 | cc5ed | 3144 3144 |
| 28414 | 28414 | 27335 | 3144 3144 |
| 28415 | 28415 | 371f0 | 3144 3144 |
| 28416 | 28416 | 59d75 | 3144 3144 |
| 28417 | 28417 | e6200 | 3144 3144 |
| 28418 | 28418 | b1201 | 3144 3144 |
| 28419 | 28419 | 902e5 | 3144 3144 |
| 28420 | 28420 | 8a7ee | 3144 3144 |
| 28421 | 28421 | 862ed | 3144 3144 |
| 28422 | 28422 | a1307 | 3144 3144 |
| 28423 | 28423 | abb72 | 3144 3144 |
| 28424 | 28424 | 27369 | 3144 3144 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)