This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36575 | 36575 | cc5ed | 1259 1259 |
| 36576 | 36576 | 371f0 | 1259 1259 |
| 36577 | 36577 | e6200 | 1259 1259 |
| 36578 | 36578 | b1201 | 1259 1259 |
| 36579 | 36579 | 902e5 | 1259 1259 |
| 36580 | 36580 | 8123a | 1259 1259 |
| 36581 | 36581 | 172e0 | 1259 1259 |
| 36582 | 36582 | 45a71 | 1259 1259 |
| 36583 | 36583 | 5d37b | 1259 1259 |
| 36584 | 36584 | 70fc3 | 1259 1259 |
| 36585 | 36585 | 58753 | 1259 1259 |
| 36586 | 36586 | cf4f6 | 1259 1259 |
| 36587 | 36587 | e5c05 | 1259 1259 |
| 36588 | 36588 | c85cd | 1259 1259 |
| 36589 | 36589 | f5d72 | 1259 1259 |
| 36590 | 36590 | a0884 | 1259 1259 |
| 36591 | 36591 | 9eb05 | 1259 1259 |
| 36592 | 36592 | b8e89 | 1259 1259 |
| 36593 | 36593 | 37b83 | 1259 1259 |
| 36594 | 36594 | ff90c | 1259 1259 |
| 36595 | 36595 | 0335c | 1259 1259 |
| 36596 | 36596 | e1707 | 1259 1259 |
| 36597 | 36597 | e58e0 | 1259 1259 |
| 36598 | 36598 | 87070 | 1259 1259 |
| 36599 | 36599 | 79cab | 1259 1259 |
| 36600 | 36600 | 8152e | 1259 1259 |
| 36601 | 36601 | 2a1b9 | 1259 1259 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)