This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 906 | 906 | cc5ed | 2243 2243 |
| 907 | 907 | 371f0 | 2243 2243 |
| 908 | 908 | e6200 | 2243 2243 |
| 909 | 909 | b1201 | 2243 2243 |
| 910 | 910 | 8a7ee | 2243 2243 |
| 911 | 911 | 862ed | 2243 2243 |
| 912 | 912 | a2d21 | 2243 2243 |
| 913 | 913 | 9c846 | 2243 2243 |
| 914 | 914 | 4225c | 2243 2243 |
| 915 | 915 | 27369 | 2243 2243 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)