This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33629 | 33629 | ec3ac | 773 773 |
| 33630 | 33630 | b668a | 773 773 |
| 33631 | 33631 | a14cf | 773 773 |
| 33632 | 33632 | 5e075 | 773 773 |
| 33633 | 33633 | 59d75 | 773 773 |
| 33634 | 33634 | e6200 | 773 773 |
| 33635 | 33635 | b1201 | 773 773 |
| 33636 | 33636 | b42a4 | 773 773 |
| 33637 | 33637 | d679e | 773 773 |
| 33638 | 33638 | 17bc7 | 773 773 |
| 33639 | 33639 | aa04d | 773 773 |
| 33640 | 33640 | 95f91 | 773 773 |
| 33641 | 33641 | 65a38 | 773 773 |
| 33642 | 33642 | e128e | 773 773 |
| 33643 | 33643 | d75c0 | 773 773 |
| 33644 | 33644 | 16071 | 773 773 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)