This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21310 | 21310 | ec3ac | 978 978 |
| 21311 | 21311 | 4801f | 978 978 |
| 21312 | 21312 | 5e075 | 978 978 |
| 21313 | 21313 | 59d75 | 978 978 |
| 21314 | 21314 | e6200 | 978 978 |
| 21315 | 21315 | b1201 | 978 978 |
| 21316 | 21316 | d6347 | 978 978 |
| 21317 | 21317 | ebf60 | 978 978 |
| 21318 | 21318 | 9a8c6 | 978 978 |
| 21319 | 21319 | 91693 | 978 978 |
| 21320 | 21320 | 1d2ab | 978 978 |
| 21321 | 21321 | abb72 | 978 978 |
| 21322 | 21322 | 41b26 | 978 978 |
| 21323 | 21323 | 2db78 | 978 978 |
| 21324 | 21324 | 6a38c | 978 978 |
| 21325 | 21325 | e128e | 978 978 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)