This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24430 | 24430 | cc5ed | 2921 2921 |
| 24431 | 24431 | c1190 | 2921 2921 |
| 24432 | 24432 | cb80d | 2921 2921 |
| 24433 | 24433 | 371f0 | 2921 2921 |
| 24434 | 24434 | bf1e7 | 2921 2921 |
| 24435 | 24435 | e6200 | 2921 2921 |
| 24436 | 24436 | b1201 | 2921 2921 |
| 24437 | 24437 | 902e5 | 2921 2921 |
| 24438 | 24438 | bc1ac | 2921 2921 |
| 24439 | 24439 | 6ec75 | 2921 2921 |
| 24440 | 24440 | 5b456 | 2921 2921 |
| 24441 | 24441 | 77d7e | 2921 2921 |
| 24442 | 24442 | 88f4a | 2921 2921 |
| 24443 | 24443 | ed59f | 2921 2921 |
| 24444 | 24444 | 1aa29 | 2921 2921 |
| 24445 | 24445 | 51ad1 | 2921 2921 |
| 24446 | 24446 | b0c29 | 2921 2921 |
| 24447 | 24447 | 87529 | 2921 2921 |
| 24448 | 24448 | 266f1 | 2921 2921 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)