This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12278 | 12278 | dcb4d | 1951 1951 |
| 12279 | 12279 | 333ba | 1951 1951 |
| 12280 | 12280 | cf7dd | 1951 1951 |
| 12281 | 12281 | c448c | 1951 1951 |
| 12282 | 12282 | 4fb1f | 1951 1951 |
| 12283 | 12283 | 06abe | 1951 1951 |
| 12284 | 12284 | dfcf1 | 1951 1951 |
| 12285 | 12285 | 1b75e | 1951 1951 |
| 12286 | 12286 | 2a4ca | 1951 1951 |
| 12287 | 12287 | b08d4 | 1951 1951 |
| 12288 | 12288 | 3f4e7 | 1951 1951 |
| 12289 | 12289 | 3df1f | 1951 1951 |
| 12290 | 12290 | 027ea | 1951 1951 |
| 12291 | 12291 | f18cc | 1951 1951 |
| 12292 | 12292 | d1e7b | 1951 1951 |
| 12293 | 12293 | 3502d | 1951 1951 |
| 12294 | 12294 | ebba7 | 1951 1951 |
| 12295 | 12295 | 1518e | 1951 1951 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)