This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28501 | 28501 | ec3ac | 3195 3195 |
| 28502 | 28502 | 371f0 | 3195 3195 |
| 28503 | 28503 | e6200 | 3195 3195 |
| 28504 | 28504 | b1201 | 3195 3195 |
| 28505 | 28505 | 8a7ee | 3195 3195 |
| 28506 | 28506 | 862ed | 3195 3195 |
| 28507 | 28507 | 6ec75 | 3195 3195 |
| 28508 | 28508 | a2d21 | 3195 3195 |
| 28509 | 28509 | a1307 | 3195 3195 |
| 28510 | 28510 | 77d7e | 3195 3195 |
| 28511 | 28511 | 4225c | 3195 3195 |
| 28512 | 28512 | 27369 | 3195 3195 |
| 28513 | 28513 | e128e | 3195 3195 |
| 28514 | 28514 | feaa7 | 3195 3195 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)