This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15941 | 15941 | 189ac | 2372 2372 |
| 15942 | 15942 | 371f0 | 2372 2372 |
| 15943 | 15943 | e6200 | 2372 2372 |
| 15944 | 15944 | b1201 | 2372 2372 |
| 15945 | 15945 | 5e6f8 | 2372 2372 |
| 15946 | 15946 | 463ae | 2372 2372 |
| 15947 | 15947 | 93324 | 2372 2372 |
| 15948 | 15948 | f9b79 | 2372 2372 |
| 15949 | 15949 | 06ae5 | 2372 2372 |
| 15950 | 15950 | 710d1 | 2372 2372 |
| 15951 | 15951 | e737a | 2372 2372 |
| 15952 | 15952 | c45c4 | 2372 2372 |
| 15953 | 15953 | 60bee | 2372 2372 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)