This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22193 | 22193 | ec3ac | 989 989 |
| 22194 | 22194 | 4801f | 989 989 |
| 22195 | 22195 | 5e075 | 989 989 |
| 22196 | 22196 | 59d75 | 989 989 |
| 22197 | 22197 | e6200 | 989 989 |
| 22198 | 22198 | b1201 | 989 989 |
| 22199 | 22199 | d6347 | 989 989 |
| 22200 | 22200 | ebf60 | 989 989 |
| 22201 | 22201 | 9a8c6 | 989 989 |
| 22202 | 22202 | a2d21 | 989 989 |
| 22203 | 22203 | a1307 | 989 989 |
| 22204 | 22204 | abb72 | 989 989 |
| 22205 | 22205 | 41b26 | 989 989 |
| 22206 | 22206 | 2db78 | 989 989 |
| 22207 | 22207 | 6a38c | 989 989 |
| 22208 | 22208 | e128e | 989 989 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)