This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26450 | 26450 | cc5ed | 3391 3391 |
| 26451 | 26451 | cba3e | 3391 3391 |
| 26452 | 26452 | 371f0 | 3391 3391 |
| 26453 | 26453 | bf1e7 | 3391 3391 |
| 26454 | 26454 | e6200 | 3391 3391 |
| 26455 | 26455 | b1201 | 3391 3391 |
| 26456 | 26456 | 902e5 | 3391 3391 |
| 26457 | 26457 | 1c6ee | 3391 3391 |
| 26458 | 26458 | ecafd | 3391 3391 |
| 26459 | 26459 | f1655 | 3391 3391 |
| 26460 | 26460 | 14d09 | 3391 3391 |
| 26461 | 26461 | 78f62 | 3391 3391 |
| 26462 | 26462 | 5eedc | 3391 3391 |
| 26463 | 26463 | 21f8d | 3391 3391 |
| 26464 | 26464 | 2cd21 | 3391 3391 |
| 26465 | 26465 | a9887 | 3391 3391 |
| 26466 | 26466 | a9339 | 3391 3391 |
| 26467 | 26467 | f0980 | 3391 3391 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)