This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17 | 17 | c46d7 | 3186 3186 |
| 846 | 846 | c46d7 | 3179 3179 |
| 5350 | 5350 | c46d7 | 2955 2955 |
| 7672 | 7672 | c46d7 | 2965 2965 |
| 17280 | 17280 | c46d7 | 2960 2960 |
| 21346 | 21346 | c46d7 | 2898 2898 |
| 21917 | 21917 | c46d7 | 2950 2950 |
| 23560 | 23560 | c46d7 | 2934 2934 |
| 23619 | 23619 | c46d7 | 2911 2911 |
| 23672 | 23672 | c46d7 | 2917 2917 |
| 24016 | 24016 | c46d7 | 2912 2912 |
| 24154 | 24154 | c46d7 | 2909 2909 |
| 24555 | 24555 | c46d7 | 2933 2933 |
| 24843 | 24843 | c46d7 | 2910 2910 |
| 24913 | 24913 | c46d7 | 2907 2907 |
| 25002 | 25002 | c46d7 | 2937 2937 |
| 25151 | 25151 | c46d7 | 2935 2935 |
| 25242 | 25242 | c46d7 | 2923 2923 |
| 25302 | 25302 | c46d7 | 2936 2936 |
| 25339 | 25339 | c46d7 | 2932 2932 |
| 25807 | 25807 | c46d7 | 2908 2908 |
| 28448 | 28448 | c46d7 | 3181 3181 |
| 28847 | 28847 | c46d7 | 3180 3180 |
| 36212 | 36212 | c46d7 | 2969 2969 |
| 36363 | 36363 | c46d7 | 2968 2968 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)