This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28171 | 28171 | ec3ac | 944 944 |
| 28172 | 28172 | 4801f | 944 944 |
| 28173 | 28173 | 5e075 | 944 944 |
| 28174 | 28174 | 59d75 | 944 944 |
| 28175 | 28175 | e6200 | 944 944 |
| 28176 | 28176 | b1201 | 944 944 |
| 28177 | 28177 | d6347 | 944 944 |
| 28178 | 28178 | ebf60 | 944 944 |
| 28179 | 28179 | 9a8c6 | 944 944 |
| 28180 | 28180 | 91693 | 944 944 |
| 28181 | 28181 | 1d2ab | 944 944 |
| 28182 | 28182 | abb72 | 944 944 |
| 28183 | 28183 | 41b26 | 944 944 |
| 28184 | 28184 | 2db78 | 944 944 |
| 28185 | 28185 | 6a38c | 944 944 |
| 28186 | 28186 | e128e | 944 944 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)