This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34949 | 34949 | ec3ac | 1948 1948 |
| 34950 | 34950 | 371f0 | 1948 1948 |
| 34951 | 34951 | 59d75 | 1948 1948 |
| 34952 | 34952 | 3502d | 1948 1948 |
| 34953 | 34953 | 50283 | 1948 1948 |
| 34954 | 34954 | 42004 | 1948 1948 |
| 34955 | 34955 | 19a58 | 1948 1948 |
| 34956 | 34956 | 3d056 | 1948 1948 |
| 34957 | 34957 | e6fee | 1948 1948 |
| 34958 | 34958 | 2a4f4 | 1948 1948 |
| 34959 | 34959 | 6acab | 1948 1948 |
| 34960 | 34960 | cca0f | 1948 1948 |
| 34961 | 34961 | ac3f7 | 1948 1948 |
| 34962 | 34962 | e5b4a | 1948 1948 |
| 34963 | 34963 | 21a80 | 1948 1948 |
| 34964 | 34964 | 009ee | 1948 1948 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)