This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16738 | 16738 | ec3ac | 3371 3371 |
| 16739 | 16739 | fe5f2 | 3371 3371 |
| 16740 | 16740 | 7b150 | 3371 3371 |
| 16741 | 16741 | 5e075 | 3371 3371 |
| 16742 | 16742 | 59d75 | 3371 3371 |
| 16743 | 16743 | e6200 | 3371 3371 |
| 16744 | 16744 | b1201 | 3371 3371 |
| 16745 | 16745 | 902e5 | 3371 3371 |
| 16746 | 16746 | 8a7ee | 3371 3371 |
| 16747 | 16747 | 862ed | 3371 3371 |
| 16748 | 16748 | 91693 | 3371 3371 |
| 16749 | 16749 | a1307 | 3371 3371 |
| 16750 | 16750 | abb72 | 3371 3371 |
| 16751 | 16751 | 27369 | 3371 3371 |
| 16752 | 16752 | 724f8 | 3371 3371 |
| 16753 | 16753 | e8b05 | 3371 3371 |
| 16754 | 16754 | 8b0bf | 3371 3371 |
| 16755 | 16755 | 8183a | 3371 3371 |
| 16756 | 16756 | 425d7 | 3371 3371 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)