This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34803 | 34803 | ec3ac | 1915 1915 |
| 34804 | 34804 | 371f0 | 1915 1915 |
| 34805 | 34805 | 59d75 | 1915 1915 |
| 34806 | 34806 | 3502d | 1915 1915 |
| 34807 | 34807 | 03f36 | 1915 1915 |
| 34808 | 34808 | cf7f4 | 1915 1915 |
| 34809 | 34809 | 4ccae | 1915 1915 |
| 34810 | 34810 | a9066 | 1915 1915 |
| 34811 | 34811 | 48d30 | 1915 1915 |
| 34812 | 34812 | 5eb64 | 1915 1915 |
| 34813 | 34813 | 336f0 | 1915 1915 |
| 34814 | 34814 | ecdee | 1915 1915 |
| 34815 | 34815 | 8d892 | 1915 1915 |
| 34816 | 34816 | 491fd | 1915 1915 |
| 34817 | 34817 | a4c1d | 1915 1915 |
| 34818 | 34818 | 88cb7 | 1915 1915 |
| 34819 | 34819 | bc89e | 1915 1915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)