This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34607 | 34607 | f6566 | 1910 1910 |
| 34608 | 34608 | 49b74 | 1910 1910 |
| 34609 | 34609 | 384b9 | 1910 1910 |
| 34610 | 34610 | aa920 | 1910 1910 |
| 34611 | 34611 | 508a5 | 1910 1910 |
| 34612 | 34612 | 371f0 | 1910 1910 |
| 34613 | 34613 | 59d75 | 1910 1910 |
| 34614 | 34614 | 3502d | 1910 1910 |
| 34615 | 34615 | 3f2a6 | 1910 1910 |
| 34616 | 34616 | a94d7 | 1910 1910 |
| 34617 | 34617 | 15968 | 1910 1910 |
| 34618 | 34618 | bb3a2 | 1910 1910 |
| 34619 | 34619 | ab8e0 | 1910 1910 |
| 34620 | 34620 | 8355d | 1910 1910 |
| 34621 | 34621 | 77d7e | 1910 1910 |
| 34622 | 34622 | 40a0a | 1910 1910 |
| 34623 | 34623 | a2a44 | 1910 1910 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)