This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7426 | 7426 | ec3ac | 1090 1090 |
| 7427 | 7427 | 16102 | 1090 1090 |
| 7428 | 7428 | e9db4 | 1090 1090 |
| 7429 | 7429 | 1f895 | 1090 1090 |
| 7430 | 7430 | a5df2 | 1090 1090 |
| 7431 | 7431 | c3780 | 1090 1090 |
| 7432 | 7432 | d582c | 1090 1090 |
| 7433 | 7433 | cbcce | 1090 1090 |
| 7434 | 7434 | 1073c | 1090 1090 |
| 7435 | 7435 | 4801f | 1090 1090 |
| 7436 | 7436 | 5e075 | 1090 1090 |
| 7437 | 7437 | 59d75 | 1090 1090 |
| 7438 | 7438 | e6200 | 1090 1090 |
| 7439 | 7439 | b1201 | 1090 1090 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)