This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5250 | 5250 | c6b59 | 2312 2312 |
| 5382 | 5382 | c6b59 | 2274 2274 |
| 5703 | 5703 | c6b59 | 2376 2376 |
| 5831 | 5831 | c6b59 | 2231 2231 |
| 6119 | 6119 | c6b59 | 2240 2240 |
| 6606 | 6606 | c6b59 | 2287 2287 |
| 6809 | 6809 | c6b59 | 2204 2204 |
| 7235 | 7235 | c6b59 | 2268 2268 |
| 7440 | 7440 | c6b59 | 2354 2354 |
| 7564 | 7564 | c6b59 | 2221 2221 |
| 7616 | 7616 | c6b59 | 2258 2258 |
| 7704 | 7704 | c6b59 | 2298 2298 |
| 7785 | 7785 | c6b59 | 2399 2399 |
| 7985 | 7985 | c6b59 | 2213 2213 |
| 8031 | 8031 | c6b59 | 2342 2342 |
| 8191 | 8191 | c6b59 | 2253 2253 |
| 8214 | 8214 | c6b59 | 2337 2337 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)