This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34108 | 34108 | ec3ac | 814 814 |
| 34109 | 34109 | b668a | 814 814 |
| 34110 | 34110 | a14cf | 814 814 |
| 34111 | 34111 | 5e075 | 814 814 |
| 34112 | 34112 | 59d75 | 814 814 |
| 34113 | 34113 | e6200 | 814 814 |
| 34114 | 34114 | b1201 | 814 814 |
| 34115 | 34115 | b42a4 | 814 814 |
| 34116 | 34116 | d679e | 814 814 |
| 34117 | 34117 | 17bc7 | 814 814 |
| 34118 | 34118 | aa04d | 814 814 |
| 34119 | 34119 | 95f91 | 814 814 |
| 34120 | 34120 | 65a38 | 814 814 |
| 34121 | 34121 | e128e | 814 814 |
| 34122 | 34122 | d75c0 | 814 814 |
| 34123 | 34123 | 16071 | 814 814 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)