This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36314 | 36314 | ec3ac | 2799 2799 |
| 36315 | 36315 | e4503 | 2799 2799 |
| 36316 | 36316 | 371f0 | 2799 2799 |
| 36317 | 36317 | 5e075 | 2799 2799 |
| 36318 | 36318 | 59d75 | 2799 2799 |
| 36319 | 36319 | e6200 | 2799 2799 |
| 36320 | 36320 | b1201 | 2799 2799 |
| 36321 | 36321 | 902e5 | 2799 2799 |
| 36322 | 36322 | f788a | 2799 2799 |
| 36323 | 36323 | e128e | 2799 2799 |
| 36324 | 36324 | 943de | 2799 2799 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)