This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1400 | 1400 | ec3ac | 1179 1179 |
| 1401 | 1401 | 17183 | 1179 1179 |
| 1402 | 1402 | 96bbd | 1179 1179 |
| 1403 | 1403 | 550f6 | 1179 1179 |
| 1404 | 1404 | 343d8 | 1179 1179 |
| 1405 | 1405 | 313af | 1179 1179 |
| 1406 | 1406 | f9cc2 | 1179 1179 |
| 1407 | 1407 | aabe0 | 1179 1179 |
| 1408 | 1408 | 3e5f6 | 1179 1179 |
| 1409 | 1409 | 87fac | 1179 1179 |
| 1410 | 1410 | 1073c | 1179 1179 |
| 1411 | 1411 | 4801f | 1179 1179 |
| 1412 | 1412 | 5e075 | 1179 1179 |
| 1413 | 1413 | 59d75 | 1179 1179 |
| 1414 | 1414 | e6200 | 1179 1179 |
| 1415 | 1415 | b1201 | 1179 1179 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)