This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24543 | 24543 | cc5ed | 2933 2933 |
| 24544 | 24544 | c1190 | 2933 2933 |
| 24545 | 24545 | cb80d | 2933 2933 |
| 24546 | 24546 | 371f0 | 2933 2933 |
| 24547 | 24547 | bf1e7 | 2933 2933 |
| 24548 | 24548 | e6200 | 2933 2933 |
| 24549 | 24549 | b1201 | 2933 2933 |
| 24550 | 24550 | 902e5 | 2933 2933 |
| 24551 | 24551 | bc1ac | 2933 2933 |
| 24552 | 24552 | 6ec75 | 2933 2933 |
| 24553 | 24553 | 5b456 | 2933 2933 |
| 24554 | 24554 | 77d7e | 2933 2933 |
| 24555 | 24555 | c46d7 | 2933 2933 |
| 24556 | 24556 | e5437 | 2933 2933 |
| 24557 | 24557 | 469ba | 2933 2933 |
| 24558 | 24558 | feaa7 | 2933 2933 |
| 24559 | 24559 | 1aa29 | 2933 2933 |
| 24560 | 24560 | b0c29 | 2933 2933 |
| 24561 | 24561 | 87529 | 2933 2933 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)