This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6617 | 6617 | bffb8 | 1619 1619 |
| 6618 | 6618 | 49b74 | 1619 1619 |
| 6619 | 6619 | 169d2 | 1619 1619 |
| 6620 | 6620 | 70544 | 1619 1619 |
| 6621 | 6621 | 2a4ca | 1619 1619 |
| 6622 | 6622 | 57006 | 1619 1619 |
| 6623 | 6623 | 9eadd | 1619 1619 |
| 6624 | 6624 | 18d8d | 1619 1619 |
| 6625 | 6625 | 4de4f | 1619 1619 |
| 6626 | 6626 | a14cf | 1619 1619 |
| 6627 | 6627 | 5e075 | 1619 1619 |
| 6628 | 6628 | 59d75 | 1619 1619 |
| 6629 | 6629 | e6200 | 1619 1619 |
| 6630 | 6630 | b1201 | 1619 1619 |
| 6631 | 6631 | 902e5 | 1619 1619 |
| 6632 | 6632 | 03f36 | 1619 1619 |
| 6633 | 6633 | cf7f4 | 1619 1619 |
| 6634 | 6634 | a9066 | 1619 1619 |
| 6635 | 6635 | d976f | 1619 1619 |
| 6636 | 6636 | d7035 | 1619 1619 |
| 6637 | 6637 | e31e2 | 1619 1619 |
| 6638 | 6638 | a4c1d | 1619 1619 |
| 6639 | 6639 | 46194 | 1619 1619 |
| 6640 | 6640 | d8324 | 1619 1619 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)