This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6943 | 6943 | ec3ac | 1066 1066 |
| 6944 | 6944 | 17183 | 1066 1066 |
| 6945 | 6945 | fd7d6 | 1066 1066 |
| 6946 | 6946 | d4179 | 1066 1066 |
| 6947 | 6947 | 313af | 1066 1066 |
| 6948 | 6948 | ebe26 | 1066 1066 |
| 6949 | 6949 | aabe0 | 1066 1066 |
| 6950 | 6950 | e38cb | 1066 1066 |
| 6951 | 6951 | 1073c | 1066 1066 |
| 6952 | 6952 | 4801f | 1066 1066 |
| 6953 | 6953 | 5e075 | 1066 1066 |
| 6954 | 6954 | 59d75 | 1066 1066 |
| 6955 | 6955 | e6200 | 1066 1066 |
| 6956 | 6956 | b1201 | 1066 1066 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)