This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31579 | 31579 | ec3ac | 832 832 |
| 31580 | 31580 | 59b7b | 832 832 |
| 31581 | 31581 | aaf5a | 832 832 |
| 31582 | 31582 | 5e075 | 832 832 |
| 31583 | 31583 | 59d75 | 832 832 |
| 31584 | 31584 | e6200 | 832 832 |
| 31585 | 31585 | b1201 | 832 832 |
| 31586 | 31586 | 63e96 | 832 832 |
| 31587 | 31587 | 2fb27 | 832 832 |
| 31588 | 31588 | 2f71d | 832 832 |
| 31589 | 31589 | 0bddc | 832 832 |
| 31590 | 31590 | eecd9 | 832 832 |
| 31591 | 31591 | 7ce59 | 832 832 |
| 31592 | 31592 | b8d0a | 832 832 |
| 31593 | 31593 | 3896c | 832 832 |
| 31594 | 31594 | a524c | 832 832 |
| 31595 | 31595 | 41ee7 | 832 832 |
| 31596 | 31596 | ed356 | 832 832 |
| 31597 | 31597 | 94bdc | 832 832 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)