This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5269 | 5269 | ec3ac | 1665 1665 |
| 5270 | 5270 | 4de4f | 1665 1665 |
| 5271 | 5271 | 0d60c | 1665 1665 |
| 5272 | 5272 | 5e075 | 1665 1665 |
| 5273 | 5273 | 59d75 | 1665 1665 |
| 5274 | 5274 | e6200 | 1665 1665 |
| 5275 | 5275 | b1201 | 1665 1665 |
| 5276 | 5276 | 902e5 | 1665 1665 |
| 5277 | 5277 | 03f36 | 1665 1665 |
| 5278 | 5278 | cf7f4 | 1665 1665 |
| 5279 | 5279 | a9066 | 1665 1665 |
| 5280 | 5280 | d976f | 1665 1665 |
| 5281 | 5281 | d7035 | 1665 1665 |
| 5282 | 5282 | e31e2 | 1665 1665 |
| 5283 | 5283 | a4c1d | 1665 1665 |
| 5284 | 5284 | 46194 | 1665 1665 |
| 5285 | 5285 | d8324 | 1665 1665 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)