This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15583 | 15583 | ec3ac | 1030 1030 |
| 15584 | 15584 | 4801f | 1030 1030 |
| 15585 | 15585 | 5e075 | 1030 1030 |
| 15586 | 15586 | 59d75 | 1030 1030 |
| 15587 | 15587 | e6200 | 1030 1030 |
| 15588 | 15588 | b1201 | 1030 1030 |
| 15589 | 15589 | d6347 | 1030 1030 |
| 15590 | 15590 | ebf60 | 1030 1030 |
| 15591 | 15591 | 9a8c6 | 1030 1030 |
| 15592 | 15592 | a2d21 | 1030 1030 |
| 15593 | 15593 | a1307 | 1030 1030 |
| 15594 | 15594 | abb72 | 1030 1030 |
| 15595 | 15595 | 41b26 | 1030 1030 |
| 15596 | 15596 | 2db78 | 1030 1030 |
| 15597 | 15597 | 6a38c | 1030 1030 |
| 15598 | 15598 | e128e | 1030 1030 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)