This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29534 | 29534 | cc5ed | 3068 3068 |
| 29535 | 29535 | d6ade | 3068 3068 |
| 29536 | 29536 | 8e7b3 | 3068 3068 |
| 29537 | 29537 | ebede | 3068 3068 |
| 29538 | 29538 | 343d8 | 3068 3068 |
| 29539 | 29539 | 313af | 3068 3068 |
| 29540 | 29540 | f9cc2 | 3068 3068 |
| 29541 | 29541 | a0f55 | 3068 3068 |
| 29542 | 29542 | 81536 | 3068 3068 |
| 29543 | 29543 | 3bf90 | 3068 3068 |
| 29544 | 29544 | 2f957 | 3068 3068 |
| 29545 | 29545 | 371f0 | 3068 3068 |
| 29546 | 29546 | e6200 | 3068 3068 |
| 29547 | 29547 | b1201 | 3068 3068 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)