This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28251 | 28251 | ec3ac | 1053 1053 |
| 28252 | 28252 | 4801f | 1053 1053 |
| 28253 | 28253 | 5e075 | 1053 1053 |
| 28254 | 28254 | 59d75 | 1053 1053 |
| 28255 | 28255 | e6200 | 1053 1053 |
| 28256 | 28256 | b1201 | 1053 1053 |
| 28257 | 28257 | d6347 | 1053 1053 |
| 28258 | 28258 | ebf60 | 1053 1053 |
| 28259 | 28259 | 9a8c6 | 1053 1053 |
| 28260 | 28260 | 91693 | 1053 1053 |
| 28261 | 28261 | 1d2ab | 1053 1053 |
| 28262 | 28262 | abb72 | 1053 1053 |
| 28263 | 28263 | 41b26 | 1053 1053 |
| 28264 | 28264 | 2db78 | 1053 1053 |
| 28265 | 28265 | 6a38c | 1053 1053 |
| 28266 | 28266 | e128e | 1053 1053 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)