This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20960 | 20960 | ac76f | 1261 1261 |
| 20961 | 20961 | 4de4f | 1261 1261 |
| 20962 | 20962 | 7f1e9 | 1261 1261 |
| 20963 | 20963 | 5e075 | 1261 1261 |
| 20964 | 20964 | 59d75 | 1261 1261 |
| 20965 | 20965 | e6200 | 1261 1261 |
| 20966 | 20966 | b1201 | 1261 1261 |
| 20967 | 20967 | 902e5 | 1261 1261 |
| 20968 | 20968 | b0f5c | 1261 1261 |
| 20969 | 20969 | ad8b2 | 1261 1261 |
| 20970 | 20970 | 447bb | 1261 1261 |
| 20971 | 20971 | c63f5 | 1261 1261 |
| 20972 | 20972 | 0d411 | 1261 1261 |
| 20973 | 20973 | e5fdf | 1261 1261 |
| 20974 | 20974 | e5472 | 1261 1261 |
| 20975 | 20975 | 58c8b | 1261 1261 |
| 20976 | 20976 | 8c5f6 | 1261 1261 |
| 20977 | 20977 | d37d4 | 1261 1261 |
| 20978 | 20978 | ea1c6 | 1261 1261 |
| 20979 | 20979 | 7f0d3 | 1261 1261 |
| 20980 | 20980 | bd943 | 1261 1261 |
| 20981 | 20981 | a3692 | 1261 1261 |
| 20982 | 20982 | 5d467 | 1261 1261 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)