This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 132 | 132 | ec3ac | 2827 2827 |
| 133 | 133 | 3da9b | 2827 2827 |
| 134 | 134 | 7b150 | 2827 2827 |
| 135 | 135 | 59d75 | 2827 2827 |
| 136 | 136 | e6200 | 2827 2827 |
| 137 | 137 | b1201 | 2827 2827 |
| 138 | 138 | 902e5 | 2827 2827 |
| 139 | 139 | 3848b | 2827 2827 |
| 140 | 140 | 782ff | 2827 2827 |
| 141 | 141 | bbdfd | 2827 2827 |
| 142 | 142 | 1d468 | 2827 2827 |
| 143 | 143 | 6f328 | 2827 2827 |
| 144 | 144 | 0e3b6 | 2827 2827 |
| 145 | 145 | a7528 | 2827 2827 |
| 146 | 146 | 06ae5 | 2827 2827 |
| 147 | 147 | 710d1 | 2827 2827 |
| 148 | 148 | 943de | 2827 2827 |
| 149 | 149 | 016b2 | 2827 2827 |
| 150 | 150 | 5a70c | 2827 2827 |
| 151 | 151 | c45c4 | 2827 2827 |
| 152 | 152 | 60bee | 2827 2827 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)