This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 606 | 606 | 4accc | 2378 2378 |
| 1103 | 1103 | 4accc | 2377 2377 |
| 1941 | 1941 | 4accc | 2343 2343 |
| 2066 | 2066 | 4accc | 2344 2344 |
| 5328 | 5328 | 4accc | 2375 2375 |
| 5707 | 5707 | 4accc | 2376 2376 |
| 5903 | 5903 | 4accc | 2946 2946 |
| 6107 | 6107 | 4accc | 2752 2752 |
| 6322 | 6322 | 4accc | 844 844 |
| 6438 | 6438 | 4accc | 2512 2512 |
| 6514 | 6514 | 4accc | 2887 2887 |
| 6710 | 6710 | 4accc | 801 801 |
| 7120 | 7120 | 4accc | 2526 2526 |
| 7344 | 7344 | 4accc | 2341 2341 |
| 7981 | 7981 | 4accc | 800 800 |
| 8035 | 8035 | 4accc | 2342 2342 |
| 11994 | 11994 | 4accc | 1696 1696 |
| 19074 | 19074 | 4accc | 2821 2821 |
| 20365 | 20365 | 4accc | 935 935 |
| 20389 | 20389 | 4accc | 3037 3037 |
| 27641 | 27641 | 4accc | 3245 3245 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)