This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1447 | 1447 | ec3ac | 1057 1057 |
| 1448 | 1448 | 17183 | 1057 1057 |
| 1449 | 1449 | 96bbd | 1057 1057 |
| 1450 | 1450 | 550f6 | 1057 1057 |
| 1451 | 1451 | 343d8 | 1057 1057 |
| 1452 | 1452 | 313af | 1057 1057 |
| 1453 | 1453 | f9cc2 | 1057 1057 |
| 1454 | 1454 | aabe0 | 1057 1057 |
| 1455 | 1455 | 3e5f6 | 1057 1057 |
| 1456 | 1456 | 87fac | 1057 1057 |
| 1457 | 1457 | 1073c | 1057 1057 |
| 1458 | 1458 | 4801f | 1057 1057 |
| 1459 | 1459 | 5e075 | 1057 1057 |
| 1460 | 1460 | 59d75 | 1057 1057 |
| 1461 | 1461 | e6200 | 1057 1057 |
| 1462 | 1462 | b1201 | 1057 1057 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)