This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16383 | 16383 | f678f | 3338 3338 |
| 16384 | 16384 | 371f0 | 3338 3338 |
| 16385 | 16385 | 5e075 | 3338 3338 |
| 16386 | 16386 | 59d75 | 3338 3338 |
| 16387 | 16387 | e6200 | 3338 3338 |
| 16388 | 16388 | b1201 | 3338 3338 |
| 16389 | 16389 | a50f7 | 3338 3338 |
| 16390 | 16390 | d5ec6 | 3338 3338 |
| 16391 | 16391 | d3559 | 3338 3338 |
| 16392 | 16392 | 649a5 | 3338 3338 |
| 16393 | 16393 | 8a7eb | 3338 3338 |
| 16394 | 16394 | 18a11 | 3338 3338 |
| 16395 | 16395 | 03778 | 3338 3338 |
| 16396 | 16396 | a1f8b | 3338 3338 |
| 16397 | 16397 | 37724 | 3338 3338 |
| 16398 | 16398 | 32bde | 3338 3338 |
| 16399 | 16399 | 06ae5 | 3338 3338 |
| 16400 | 16400 | 710d1 | 3338 3338 |
| 16401 | 16401 | 943de | 3338 3338 |
| 16402 | 16402 | 8d650 | 3338 3338 |
| 16403 | 16403 | fa448 | 3338 3338 |
| 16404 | 16404 | e1dcf | 3338 3338 |
| 16405 | 16405 | f58f7 | 3338 3338 |
| 16406 | 16406 | 6e6b8 | 3338 3338 |
| 16407 | 16407 | e737a | 3338 3338 |
| 16408 | 16408 | e7176 | 3338 3338 |
| 16409 | 16409 | 376eb | 3338 3338 |
| 16410 | 16410 | 2ed38 | 3338 3338 |
| 16411 | 16411 | 60bee | 3338 3338 |
| 16412 | 16412 | 962c9 | 3338 3338 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)