This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 49 | 49 | ec3ac | 1139 1139 |
| 50 | 50 | 4801f | 1139 1139 |
| 51 | 51 | 5e075 | 1139 1139 |
| 52 | 52 | 59d75 | 1139 1139 |
| 53 | 53 | e6200 | 1139 1139 |
| 54 | 54 | b1201 | 1139 1139 |
| 55 | 55 | d6347 | 1139 1139 |
| 56 | 56 | ebf60 | 1139 1139 |
| 57 | 57 | 9a8c6 | 1139 1139 |
| 58 | 58 | a2d21 | 1139 1139 |
| 59 | 59 | a1307 | 1139 1139 |
| 60 | 60 | abb72 | 1139 1139 |
| 61 | 61 | 41b26 | 1139 1139 |
| 62 | 62 | 2db78 | 1139 1139 |
| 63 | 63 | 6a38c | 1139 1139 |
| 64 | 64 | e128e | 1139 1139 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)