This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29595 | 29595 | cc5ed | 3206 3206 |
| 29596 | 29596 | 20711 | 3206 3206 |
| 29597 | 29597 | 371f0 | 3206 3206 |
| 29598 | 29598 | 5e075 | 3206 3206 |
| 29599 | 29599 | 59d75 | 3206 3206 |
| 29600 | 29600 | e6200 | 3206 3206 |
| 29601 | 29601 | b1201 | 3206 3206 |
| 29602 | 29602 | 902e5 | 3206 3206 |
| 29603 | 29603 | 8a7ee | 3206 3206 |
| 29604 | 29604 | 862ed | 3206 3206 |
| 29605 | 29605 | a1307 | 3206 3206 |
| 29606 | 29606 | abb72 | 3206 3206 |
| 29607 | 29607 | 2ce65 | 3206 3206 |
| 29608 | 29608 | 14760 | 3206 3206 |
| 29609 | 29609 | eb152 | 3206 3206 |
| 29610 | 29610 | 04629 | 3206 3206 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)