This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34031 | 34031 | ec3ac | 916 916 |
| 34032 | 34032 | b668a | 916 916 |
| 34033 | 34033 | aaf5a | 916 916 |
| 34034 | 34034 | 5e075 | 916 916 |
| 34035 | 34035 | 59d75 | 916 916 |
| 34036 | 34036 | e6200 | 916 916 |
| 34037 | 34037 | b1201 | 916 916 |
| 34038 | 34038 | b42a4 | 916 916 |
| 34039 | 34039 | d679e | 916 916 |
| 34040 | 34040 | 17bc7 | 916 916 |
| 34041 | 34041 | aa04d | 916 916 |
| 34042 | 34042 | 95f91 | 916 916 |
| 34043 | 34043 | 7ce59 | 916 916 |
| 34044 | 34044 | a524c | 916 916 |
| 34045 | 34045 | 234f1 | 916 916 |
| 34046 | 34046 | 100b7 | 916 916 |
| 34047 | 34047 | 1518e | 916 916 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)