This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10140 | 10140 | ec3ac | 884 884 |
| 10141 | 10141 | 59b7b | 884 884 |
| 10142 | 10142 | a14cf | 884 884 |
| 10143 | 10143 | 5e075 | 884 884 |
| 10144 | 10144 | 59d75 | 884 884 |
| 10145 | 10145 | e6200 | 884 884 |
| 10146 | 10146 | b1201 | 884 884 |
| 10147 | 10147 | b8d0a | 884 884 |
| 10148 | 10148 | c8e9f | 884 884 |
| 10149 | 10149 | e128e | 884 884 |
| 10150 | 10150 | 598d9 | 884 884 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)