This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15726 | 15726 | a8e8b | 3324 3324 |
| 15727 | 15727 | 7b150 | 3324 3324 |
| 15728 | 15728 | 5e075 | 3324 3324 |
| 15729 | 15729 | 59d75 | 3324 3324 |
| 15730 | 15730 | e6200 | 3324 3324 |
| 15731 | 15731 | b1201 | 3324 3324 |
| 15732 | 15732 | 8a7ee | 3324 3324 |
| 15733 | 15733 | 862ed | 3324 3324 |
| 15734 | 15734 | 13ab6 | 3324 3324 |
| 15735 | 15735 | 18a64 | 3324 3324 |
| 15736 | 15736 | 66f82 | 3324 3324 |
| 15737 | 15737 | f788a | 3324 3324 |
| 15738 | 15738 | 7c38f | 3324 3324 |
| 15739 | 15739 | df1f0 | 3324 3324 |
| 15740 | 15740 | a1307 | 3324 3324 |
| 15741 | 15741 | 809af | 3324 3324 |
| 15742 | 15742 | 4225c | 3324 3324 |
| 15743 | 15743 | 93975 | 3324 3324 |
| 15744 | 15744 | 04e82 | 3324 3324 |
| 15745 | 15745 | 94bdc | 3324 3324 |
| 15746 | 15746 | 9c206 | 3324 3324 |
| 15747 | 15747 | 7c580 | 3324 3324 |
| 15748 | 15748 | 724f8 | 3324 3324 |
| 15749 | 15749 | b6f60 | 3324 3324 |
| 15750 | 15750 | 06d39 | 3324 3324 |
| 15751 | 15751 | 2ab82 | 3324 3324 |
| 15752 | 15752 | 8b0bf | 3324 3324 |
| 15753 | 15753 | 01e8a | 3324 3324 |
| 15754 | 15754 | 2aa57 | 3324 3324 |
| 15755 | 15755 | 425d7 | 3324 3324 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)