This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22820 | 22820 | ec3ac | 1011 1011 |
| 22821 | 22821 | c3b9b | 1011 1011 |
| 22822 | 22822 | 5e075 | 1011 1011 |
| 22823 | 22823 | 59d75 | 1011 1011 |
| 22824 | 22824 | e6200 | 1011 1011 |
| 22825 | 22825 | b1201 | 1011 1011 |
| 22826 | 22826 | d6347 | 1011 1011 |
| 22827 | 22827 | 13ab6 | 1011 1011 |
| 22828 | 22828 | 9a8c6 | 1011 1011 |
| 22829 | 22829 | a2d21 | 1011 1011 |
| 22830 | 22830 | a1307 | 1011 1011 |
| 22831 | 22831 | abb72 | 1011 1011 |
| 22832 | 22832 | 41b26 | 1011 1011 |
| 22833 | 22833 | 2db78 | 1011 1011 |
| 22834 | 22834 | 6a38c | 1011 1011 |
| 22835 | 22835 | e128e | 1011 1011 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)