This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24499 | 24499 | f678f | 3318 3318 |
| 24500 | 24500 | 371f0 | 3318 3318 |
| 24501 | 24501 | 5e075 | 3318 3318 |
| 24502 | 24502 | 59d75 | 3318 3318 |
| 24503 | 24503 | e6200 | 3318 3318 |
| 24504 | 24504 | b1201 | 3318 3318 |
| 24505 | 24505 | a50f7 | 3318 3318 |
| 24506 | 24506 | d5ec6 | 3318 3318 |
| 24507 | 24507 | d3559 | 3318 3318 |
| 24508 | 24508 | 649a5 | 3318 3318 |
| 24509 | 24509 | 8a7eb | 3318 3318 |
| 24510 | 24510 | 18a11 | 3318 3318 |
| 24511 | 24511 | 03778 | 3318 3318 |
| 24512 | 24512 | a1f8b | 3318 3318 |
| 24513 | 24513 | 37724 | 3318 3318 |
| 24514 | 24514 | 32bde | 3318 3318 |
| 24515 | 24515 | 06ae5 | 3318 3318 |
| 24516 | 24516 | 710d1 | 3318 3318 |
| 24517 | 24517 | 943de | 3318 3318 |
| 24518 | 24518 | 8d650 | 3318 3318 |
| 24519 | 24519 | fa448 | 3318 3318 |
| 24520 | 24520 | e1dcf | 3318 3318 |
| 24521 | 24521 | f58f7 | 3318 3318 |
| 24522 | 24522 | 6e6b8 | 3318 3318 |
| 24523 | 24523 | e737a | 3318 3318 |
| 24524 | 24524 | e7176 | 3318 3318 |
| 24525 | 24525 | 376eb | 3318 3318 |
| 24526 | 24526 | 2ed38 | 3318 3318 |
| 24527 | 24527 | 60bee | 3318 3318 |
| 24528 | 24528 | 962c9 | 3318 3318 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)