This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25845 | 25845 | cc5ed | 2592 2592 |
| 25846 | 25846 | 371f0 | 2592 2592 |
| 25847 | 25847 | e6200 | 2592 2592 |
| 25848 | 25848 | b1201 | 2592 2592 |
| 25849 | 25849 | d9d8c | 2592 2592 |
| 25850 | 25850 | 5f10e | 2592 2592 |
| 25851 | 25851 | 5849a | 2592 2592 |
| 25852 | 25852 | eab5e | 2592 2592 |
| 25853 | 25853 | 8b401 | 2592 2592 |
| 25854 | 25854 | 007df | 2592 2592 |
| 25855 | 25855 | 5dcb2 | 2592 2592 |
| 25856 | 25856 | d3539 | 2592 2592 |
| 25857 | 25857 | 60626 | 2592 2592 |
| 25858 | 25858 | 4a957 | 2592 2592 |
| 25859 | 25859 | 839f9 | 2592 2592 |
| 25860 | 25860 | ffca2 | 2592 2592 |
| 25861 | 25861 | 4f89e | 2592 2592 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)