This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30089 | 30089 | cc5ed | 3224 3224 |
| 30090 | 30090 | d6ade | 3224 3224 |
| 30091 | 30091 | 8e7b3 | 3224 3224 |
| 30092 | 30092 | d1b15 | 3224 3224 |
| 30093 | 30093 | 5ad28 | 3224 3224 |
| 30094 | 30094 | c4200 | 3224 3224 |
| 30095 | 30095 | e0460 | 3224 3224 |
| 30096 | 30096 | ebe26 | 3224 3224 |
| 30097 | 30097 | fbbdb | 3224 3224 |
| 30098 | 30098 | a0f55 | 3224 3224 |
| 30099 | 30099 | 371f0 | 3224 3224 |
| 30100 | 30100 | e6200 | 3224 3224 |
| 30101 | 30101 | 3502d | 3224 3224 |
| 30102 | 30102 | b1201 | 3224 3224 |
| 30103 | 30103 | 04629 | 3224 3224 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)