This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29224 | 29224 | ec3ac | 3013 3013 |
| 29225 | 29225 | 6060b | 3013 3013 |
| 29226 | 29226 | 371f0 | 3013 3013 |
| 29227 | 29227 | 59d75 | 3013 3013 |
| 29228 | 29228 | e6200 | 3013 3013 |
| 29229 | 29229 | b1201 | 3013 3013 |
| 29230 | 29230 | 902e5 | 3013 3013 |
| 29231 | 29231 | 8a7ee | 3013 3013 |
| 29232 | 29232 | 862ed | 3013 3013 |
| 29233 | 29233 | d723b | 3013 3013 |
| 29234 | 29234 | a2f3f | 3013 3013 |
| 29235 | 29235 | 812ee | 3013 3013 |
| 29236 | 29236 | a0f14 | 3013 3013 |
| 29237 | 29237 | adcfe | 3013 3013 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)