This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 238 | 238 | b8c83 | 3200 3200 |
| 239 | 239 | 20711 | 3200 3200 |
| 240 | 240 | 371f0 | 3200 3200 |
| 241 | 241 | 5e075 | 3200 3200 |
| 242 | 242 | 59d75 | 3200 3200 |
| 243 | 243 | e6200 | 3200 3200 |
| 244 | 244 | b1201 | 3200 3200 |
| 245 | 245 | 902e5 | 3200 3200 |
| 246 | 246 | 8a7ee | 3200 3200 |
| 247 | 247 | 862ed | 3200 3200 |
| 248 | 248 | a1307 | 3200 3200 |
| 249 | 249 | abb72 | 3200 3200 |
| 250 | 250 | 2ce65 | 3200 3200 |
| 251 | 251 | 14760 | 3200 3200 |
| 252 | 252 | 27369 | 3200 3200 |
| 253 | 253 | 45c5d | 3200 3200 |
| 254 | 254 | 04629 | 3200 3200 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)