This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22365 | 22365 | ec3ac | 1004 1004 |
| 22366 | 22366 | 4801f | 1004 1004 |
| 22367 | 22367 | 5e075 | 1004 1004 |
| 22368 | 22368 | 59d75 | 1004 1004 |
| 22369 | 22369 | e6200 | 1004 1004 |
| 22370 | 22370 | b1201 | 1004 1004 |
| 22371 | 22371 | d6347 | 1004 1004 |
| 22372 | 22372 | ebf60 | 1004 1004 |
| 22373 | 22373 | 9a8c6 | 1004 1004 |
| 22374 | 22374 | 91693 | 1004 1004 |
| 22375 | 22375 | 1d2ab | 1004 1004 |
| 22376 | 22376 | abb72 | 1004 1004 |
| 22377 | 22377 | 41b26 | 1004 1004 |
| 22378 | 22378 | 2db78 | 1004 1004 |
| 22379 | 22379 | 6a38c | 1004 1004 |
| 22380 | 22380 | e128e | 1004 1004 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)