This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17714 | 17714 | cc5ed | 2958 2958 |
| 17715 | 17715 | cb80d | 2958 2958 |
| 17716 | 17716 | 371f0 | 2958 2958 |
| 17717 | 17717 | 59d75 | 2958 2958 |
| 17718 | 17718 | e6200 | 2958 2958 |
| 17719 | 17719 | b1201 | 2958 2958 |
| 17720 | 17720 | 902e5 | 2958 2958 |
| 17721 | 17721 | b918e | 2958 2958 |
| 17722 | 17722 | 597b7 | 2958 2958 |
| 17723 | 17723 | 53be8 | 2958 2958 |
| 17724 | 17724 | 72d8e | 2958 2958 |
| 17725 | 17725 | 1fd76 | 2958 2958 |
| 17726 | 17726 | b68ec | 2958 2958 |
| 17727 | 17727 | feaa7 | 2958 2958 |
| 17728 | 17728 | 42fde | 2958 2958 |
| 17729 | 17729 | e92f4 | 2958 2958 |
| 17730 | 17730 | dbf07 | 2958 2958 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)