This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 116 | 116 | 9f5e5 | 475 475 |
| 117 | 117 | 72597 | 475 475 |
| 118 | 118 | 371f0 | 475 475 |
| 119 | 119 | e6200 | 475 475 |
| 120 | 120 | b1201 | 475 475 |
| 121 | 121 | 902e5 | 475 475 |
| 122 | 122 | a94d7 | 475 475 |
| 123 | 123 | 6ec75 | 475 475 |
| 124 | 124 | 5b456 | 475 475 |
| 125 | 125 | ab8e0 | 475 475 |
| 126 | 126 | 8355d | 475 475 |
| 127 | 127 | d8244 | 475 475 |
| 128 | 128 | f006b | 475 475 |
| 129 | 129 | 13054 | 475 475 |
| 130 | 130 | 83826 | 475 475 |
| 131 | 131 | 7426e | 475 475 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)