This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15442 | 15442 | f6566 | 1885 1885 |
| 15443 | 15443 | 02903 | 1885 1885 |
| 15444 | 15444 | 384b9 | 1885 1885 |
| 15445 | 15445 | 169d2 | 1885 1885 |
| 15446 | 15446 | 3092a | 1885 1885 |
| 15447 | 15447 | 045ef | 1885 1885 |
| 15448 | 15448 | e0435 | 1885 1885 |
| 15449 | 15449 | aa920 | 1885 1885 |
| 15450 | 15450 | 53600 | 1885 1885 |
| 15451 | 15451 | 7ec93 | 1885 1885 |
| 15452 | 15452 | 7f1e9 | 1885 1885 |
| 15453 | 15453 | 3502d | 1885 1885 |
| 15454 | 15454 | 340b8 | 1885 1885 |
| 15455 | 15455 | e80cf | 1885 1885 |
| 15456 | 15456 | 910a8 | 1885 1885 |
| 15457 | 15457 | d745f | 1885 1885 |
| 15458 | 15458 | 801ee | 1885 1885 |
| 15459 | 15459 | 3921a | 1885 1885 |
| 15460 | 15460 | 263b7 | 1885 1885 |
| 15461 | 15461 | 53be8 | 1885 1885 |
| 15462 | 15462 | b0465 | 1885 1885 |
| 15463 | 15463 | a58bf | 1885 1885 |
| 15464 | 15464 | 04ece | 1885 1885 |
| 15465 | 15465 | 4071f | 1885 1885 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)