This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5969 | 5969 | ec3ac | 1093 1093 |
| 5970 | 5970 | 17183 | 1093 1093 |
| 5971 | 5971 | 96bbd | 1093 1093 |
| 5972 | 5972 | d4179 | 1093 1093 |
| 5973 | 5973 | 313af | 1093 1093 |
| 5974 | 5974 | ebe26 | 1093 1093 |
| 5975 | 5975 | c3780 | 1093 1093 |
| 5976 | 5976 | aabe0 | 1093 1093 |
| 5977 | 5977 | e38cb | 1093 1093 |
| 5978 | 5978 | 1073c | 1093 1093 |
| 5979 | 5979 | 4801f | 1093 1093 |
| 5980 | 5980 | 5e075 | 1093 1093 |
| 5981 | 5981 | 59d75 | 1093 1093 |
| 5982 | 5982 | e6200 | 1093 1093 |
| 5983 | 5983 | b1201 | 1093 1093 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)