This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1351 | 1351 | cc5ed | 2987 2987 |
| 1352 | 1352 | 40c27 | 2987 2987 |
| 1353 | 1353 | f4921 | 2987 2987 |
| 1354 | 1354 | 550f6 | 2987 2987 |
| 1355 | 1355 | bb74c | 2987 2987 |
| 1356 | 1356 | aabe0 | 2987 2987 |
| 1357 | 1357 | a06cb | 2987 2987 |
| 1358 | 1358 | 87fac | 2987 2987 |
| 1359 | 1359 | cbcce | 2987 2987 |
| 1360 | 1360 | 7ceb1 | 2987 2987 |
| 1361 | 1361 | 7b150 | 2987 2987 |
| 1362 | 1362 | e6200 | 2987 2987 |
| 1363 | 1363 | b1201 | 2987 2987 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)