This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1137 | 1137 | 189ac | 2369 2369 |
| 5781 | 5781 | 189ac | 2324 2324 |
| 6971 | 6971 | 189ac | 2263 2263 |
| 7277 | 7277 | 189ac | 2305 2305 |
| 7357 | 7357 | 189ac | 2403 2403 |
| 7902 | 7902 | 189ac | 2283 2283 |
| 15659 | 15659 | 189ac | 2373 2373 |
| 15691 | 15691 | 189ac | 2365 2365 |
| 15941 | 15941 | 189ac | 2372 2372 |
| 15954 | 15954 | 189ac | 2366 2366 |
| 16724 | 16724 | 189ac | 2385 2385 |
| 17850 | 17850 | 189ac | 2367 2367 |
| 17864 | 17864 | 189ac | 2386 2386 |
| 18059 | 18059 | 189ac | 2368 2368 |
| 28958 | 28958 | 189ac | 2362 2362 |
| 30556 | 30556 | 189ac | 2282 2282 |
| 30606 | 30606 | 189ac | 2323 2323 |
| 30653 | 30653 | 189ac | 2402 2402 |
| 30736 | 30736 | 189ac | 2262 2262 |
| 30782 | 30782 | 189ac | 2304 2304 |
| 30856 | 30856 | 189ac | 2290 2290 |
| 30895 | 30895 | 189ac | 2303 2303 |
| 36031 | 36031 | 189ac | 2371 2371 |
| 36075 | 36075 | 189ac | 2364 2364 |
| 36486 | 36486 | 189ac | 2384 2384 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)