This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 19505 | 19505 | cc5ed | 2186 2186 |
| 19506 | 19506 | 371f0 | 2186 2186 |
| 19507 | 19507 | e6200 | 2186 2186 |
| 19508 | 19508 | b1201 | 2186 2186 |
| 19509 | 19509 | 8a7ee | 2186 2186 |
| 19510 | 19510 | 862ed | 2186 2186 |
| 19511 | 19511 | a1307 | 2186 2186 |
| 19512 | 19512 | abb72 | 2186 2186 |
| 19513 | 19513 | 27369 | 2186 2186 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)