This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 19315 | 19315 | ec3ac | 982 982 |
| 19316 | 19316 | 4801f | 982 982 |
| 19317 | 19317 | 5e075 | 982 982 |
| 19318 | 19318 | 59d75 | 982 982 |
| 19319 | 19319 | e6200 | 982 982 |
| 19320 | 19320 | b1201 | 982 982 |
| 19321 | 19321 | d6347 | 982 982 |
| 19322 | 19322 | ebf60 | 982 982 |
| 19323 | 19323 | 9a8c6 | 982 982 |
| 19324 | 19324 | a2d21 | 982 982 |
| 19325 | 19325 | a1307 | 982 982 |
| 19326 | 19326 | abb72 | 982 982 |
| 19327 | 19327 | 41b26 | 982 982 |
| 19328 | 19328 | 2db78 | 982 982 |
| 19329 | 19329 | 6a38c | 982 982 |
| 19330 | 19330 | e128e | 982 982 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)