This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21970 | 21970 | ec3ac | 1013 1013 |
| 21971 | 21971 | c3b9b | 1013 1013 |
| 21972 | 21972 | 5e075 | 1013 1013 |
| 21973 | 21973 | 59d75 | 1013 1013 |
| 21974 | 21974 | e6200 | 1013 1013 |
| 21975 | 21975 | b1201 | 1013 1013 |
| 21976 | 21976 | d6347 | 1013 1013 |
| 21977 | 21977 | 13ab6 | 1013 1013 |
| 21978 | 21978 | 9a8c6 | 1013 1013 |
| 21979 | 21979 | a2d21 | 1013 1013 |
| 21980 | 21980 | a1307 | 1013 1013 |
| 21981 | 21981 | abb72 | 1013 1013 |
| 21982 | 21982 | 41b26 | 1013 1013 |
| 21983 | 21983 | 2db78 | 1013 1013 |
| 21984 | 21984 | 6a38c | 1013 1013 |
| 21985 | 21985 | e128e | 1013 1013 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)