This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31842 | 31842 | f6566 | 2440 2440 |
| 31843 | 31843 | 8657c | 2440 2440 |
| 31844 | 31844 | bffb8 | 2440 2440 |
| 31845 | 31845 | 49b74 | 2440 2440 |
| 31846 | 31846 | 384b9 | 2440 2440 |
| 31847 | 31847 | aa920 | 2440 2440 |
| 31848 | 31848 | b733d | 2440 2440 |
| 31849 | 31849 | 57006 | 2440 2440 |
| 31850 | 31850 | bfd83 | 2440 2440 |
| 31851 | 31851 | 9eadd | 2440 2440 |
| 31852 | 31852 | 0d4bc | 2440 2440 |
| 31853 | 31853 | 73122 | 2440 2440 |
| 31854 | 31854 | e35f3 | 2440 2440 |
| 31855 | 31855 | f38f6 | 2440 2440 |
| 31856 | 31856 | c4200 | 2440 2440 |
| 31857 | 31857 | 8a526 | 2440 2440 |
| 31858 | 31858 | 1073c | 2440 2440 |
| 31859 | 31859 | 9e156 | 2440 2440 |
| 31860 | 31860 | e6200 | 2440 2440 |
| 31861 | 31861 | b1201 | 2440 2440 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)