This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 850 | 850 | feaa7 | 3179 3179 |
| 1067 | 1067 | feaa7 | 3194 3194 |
| 5354 | 5354 | feaa7 | 2955 2955 |
| 16265 | 16265 | feaa7 | 2948 2948 |
| 16722 | 16722 | feaa7 | 2949 2949 |
| 16770 | 16770 | feaa7 | 2945 2945 |
| 16836 | 16836 | feaa7 | 2947 2947 |
| 17494 | 17494 | feaa7 | 2964 2964 |
| 17727 | 17727 | feaa7 | 2958 2958 |
| 18305 | 18305 | feaa7 | 2959 2959 |
| 21347 | 21347 | feaa7 | 2898 2898 |
| 23563 | 23563 | feaa7 | 2934 2934 |
| 24157 | 24157 | feaa7 | 2909 2909 |
| 24187 | 24187 | feaa7 | 2899 2899 |
| 24558 | 24558 | feaa7 | 2933 2933 |
| 24916 | 24916 | feaa7 | 2907 2907 |
| 25243 | 25243 | feaa7 | 2923 2923 |
| 25342 | 25342 | feaa7 | 2932 2932 |
| 25519 | 25519 | feaa7 | 2924 2924 |
| 25810 | 25810 | feaa7 | 2908 2908 |
| 28453 | 28453 | feaa7 | 3181 3181 |
| 28514 | 28514 | feaa7 | 3195 3195 |
| 28851 | 28851 | feaa7 | 3180 3180 |
| 29344 | 29344 | feaa7 | 3192 3192 |
| 30281 | 30281 | feaa7 | 3193 3193 |
| 36216 | 36216 | feaa7 | 2969 2969 |
| 36367 | 36367 | feaa7 | 2968 2968 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)