This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23897 | 23897 | ec3ac | 1005 1005 |
| 23898 | 23898 | 4801f | 1005 1005 |
| 23899 | 23899 | 5e075 | 1005 1005 |
| 23900 | 23900 | 59d75 | 1005 1005 |
| 23901 | 23901 | e6200 | 1005 1005 |
| 23902 | 23902 | b1201 | 1005 1005 |
| 23903 | 23903 | d6347 | 1005 1005 |
| 23904 | 23904 | ebf60 | 1005 1005 |
| 23905 | 23905 | 9a8c6 | 1005 1005 |
| 23906 | 23906 | 91693 | 1005 1005 |
| 23907 | 23907 | 1d2ab | 1005 1005 |
| 23908 | 23908 | abb72 | 1005 1005 |
| 23909 | 23909 | 41b26 | 1005 1005 |
| 23910 | 23910 | 2db78 | 1005 1005 |
| 23911 | 23911 | 6a38c | 1005 1005 |
| 23912 | 23912 | e128e | 1005 1005 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)