This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 609 | 609 | a340a | 2378 2378 |
| 1106 | 1106 | a340a | 2377 2377 |
| 1944 | 1944 | a340a | 2343 2343 |
| 2069 | 2069 | a340a | 2344 2344 |
| 5331 | 5331 | a340a | 2375 2375 |
| 5710 | 5710 | a340a | 2376 2376 |
| 6325 | 6325 | a340a | 844 844 |
| 6441 | 6441 | a340a | 2512 2512 |
| 6713 | 6713 | a340a | 801 801 |
| 7123 | 7123 | a340a | 2526 2526 |
| 7347 | 7347 | a340a | 2341 2341 |
| 7984 | 7984 | a340a | 800 800 |
| 8038 | 8038 | a340a | 2342 2342 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)