This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28980 | 28980 | cc5ed | 2879 2879 |
| 28981 | 28981 | 3da9b | 2879 2879 |
| 28982 | 28982 | 371f0 | 2879 2879 |
| 28983 | 28983 | 5e075 | 2879 2879 |
| 28984 | 28984 | 59d75 | 2879 2879 |
| 28985 | 28985 | e6200 | 2879 2879 |
| 28986 | 28986 | b1201 | 2879 2879 |
| 28987 | 28987 | 8a7ee | 2879 2879 |
| 28988 | 28988 | 862ed | 2879 2879 |
| 28989 | 28989 | f788a | 2879 2879 |
| 28990 | 28990 | 9848a | 2879 2879 |
| 28991 | 28991 | abb72 | 2879 2879 |
| 28992 | 28992 | 27369 | 2879 2879 |
| 28993 | 28993 | e128e | 2879 2879 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)