This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5117 | 5117 | ec3ac | 3003 3003 |
| 5118 | 5118 | 6060b | 3003 3003 |
| 5119 | 5119 | 371f0 | 3003 3003 |
| 5120 | 5120 | 59d75 | 3003 3003 |
| 5121 | 5121 | e6200 | 3003 3003 |
| 5122 | 5122 | b1201 | 3003 3003 |
| 5123 | 5123 | 902e5 | 3003 3003 |
| 5124 | 5124 | 8a7ee | 3003 3003 |
| 5125 | 5125 | 862ed | 3003 3003 |
| 5126 | 5126 | 6a9d7 | 3003 3003 |
| 5127 | 5127 | 225c8 | 3003 3003 |
| 5128 | 5128 | e4b8e | 3003 3003 |
| 5129 | 5129 | 74a3a | 3003 3003 |
| 5130 | 5130 | d827a | 3003 3003 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)