This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34786 | 34786 | ec3ac | 1950 1950 |
| 34787 | 34787 | 371f0 | 1950 1950 |
| 34788 | 34788 | 59d75 | 1950 1950 |
| 34789 | 34789 | 3502d | 1950 1950 |
| 34790 | 34790 | 8a7ee | 1950 1950 |
| 34791 | 34791 | 862ed | 1950 1950 |
| 34792 | 34792 | 18a64 | 1950 1950 |
| 34793 | 34793 | 5ea35 | 1950 1950 |
| 34794 | 34794 | d65e1 | 1950 1950 |
| 34795 | 34795 | f788a | 1950 1950 |
| 34796 | 34796 | 7c38f | 1950 1950 |
| 34797 | 34797 | d1aa5 | 1950 1950 |
| 34798 | 34798 | a1307 | 1950 1950 |
| 34799 | 34799 | 2ce65 | 1950 1950 |
| 34800 | 34800 | 72a45 | 1950 1950 |
| 34801 | 34801 | 65f5f | 1950 1950 |
| 34802 | 34802 | 27369 | 1950 1950 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)