This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30173 | 30173 | cc5ed | 2861 2861 |
| 30174 | 30174 | 3da9b | 2861 2861 |
| 30175 | 30175 | 7b150 | 2861 2861 |
| 30176 | 30176 | 5e075 | 2861 2861 |
| 30177 | 30177 | 59d75 | 2861 2861 |
| 30178 | 30178 | e6200 | 2861 2861 |
| 30179 | 30179 | b1201 | 2861 2861 |
| 30180 | 30180 | 8a7ee | 2861 2861 |
| 30181 | 30181 | 862ed | 2861 2861 |
| 30182 | 30182 | f788a | 2861 2861 |
| 30183 | 30183 | d2749 | 2861 2861 |
| 30184 | 30184 | a1307 | 2861 2861 |
| 30185 | 30185 | 8d2e9 | 2861 2861 |
| 30186 | 30186 | 27369 | 2861 2861 |
| 30187 | 30187 | e128e | 2861 2861 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)