This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23548 | 23548 | cc5ed | 2934 2934 |
| 23549 | 23549 | c1190 | 2934 2934 |
| 23550 | 23550 | cb80d | 2934 2934 |
| 23551 | 23551 | 371f0 | 2934 2934 |
| 23552 | 23552 | bf1e7 | 2934 2934 |
| 23553 | 23553 | e6200 | 2934 2934 |
| 23554 | 23554 | b1201 | 2934 2934 |
| 23555 | 23555 | 902e5 | 2934 2934 |
| 23556 | 23556 | bc1ac | 2934 2934 |
| 23557 | 23557 | 6ec75 | 2934 2934 |
| 23558 | 23558 | 5b456 | 2934 2934 |
| 23559 | 23559 | 77d7e | 2934 2934 |
| 23560 | 23560 | c46d7 | 2934 2934 |
| 23561 | 23561 | e5437 | 2934 2934 |
| 23562 | 23562 | 469ba | 2934 2934 |
| 23563 | 23563 | feaa7 | 2934 2934 |
| 23564 | 23564 | 1aa29 | 2934 2934 |
| 23565 | 23565 | 87529 | 2934 2934 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)