This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9249 | 9249 | ec3ac | 1427 1427 |
| 9250 | 9250 | 16102 | 1427 1427 |
| 9251 | 9251 | 3c986 | 1427 1427 |
| 9252 | 9252 | a49a9 | 1427 1427 |
| 9253 | 9253 | 550f8 | 1427 1427 |
| 9254 | 9254 | cfef6 | 1427 1427 |
| 9255 | 9255 | 1f808 | 1427 1427 |
| 9256 | 9256 | d980a | 1427 1427 |
| 9257 | 9257 | 6b827 | 1427 1427 |
| 9258 | 9258 | 371f0 | 1427 1427 |
| 9259 | 9259 | 5e075 | 1427 1427 |
| 9260 | 9260 | 59d75 | 1427 1427 |
| 9261 | 9261 | e6200 | 1427 1427 |
| 9262 | 9262 | b1201 | 1427 1427 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)