This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9614 | 9614 | 8d4bc | 1464 1464 |
| 10086 | 10086 | 8d4bc | 1451 1451 |
| 10514 | 10514 | 8d4bc | 1437 1437 |
| 10546 | 10546 | 8d4bc | 1436 1436 |
| 10559 | 10559 | 8d4bc | 1440 1440 |
| 10598 | 10598 | 8d4bc | 1447 1447 |
| 10611 | 10611 | 8d4bc | 1454 1454 |
| 10655 | 10655 | 8d4bc | 1445 1445 |
| 10684 | 10684 | 8d4bc | 1438 1438 |
| 10712 | 10712 | 8d4bc | 1446 1446 |
| 10725 | 10725 | 8d4bc | 1453 1453 |
| 10874 | 10874 | 8d4bc | 1444 1444 |
| 10893 | 10893 | 8d4bc | 1448 1448 |
| 11154 | 11154 | 8d4bc | 1452 1452 |
| 11173 | 11173 | 8d4bc | 1450 1450 |
| 11237 | 11237 | 8d4bc | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)