This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7674 | 7674 | 1fd76 | 2965 2965 |
| 15784 | 15784 | 1fd76 | 3279 3279 |
| 15795 | 15795 | 1fd76 | 3267 3267 |
| 15985 | 15985 | 1fd76 | 3266 3266 |
| 16243 | 16243 | 1fd76 | 3265 3265 |
| 16278 | 16278 | 1fd76 | 3278 3278 |
| 16516 | 16516 | 1fd76 | 3271 3271 |
| 16688 | 16688 | 1fd76 | 3277 3277 |
| 16768 | 16768 | 1fd76 | 2945 2945 |
| 17725 | 17725 | 1fd76 | 2958 2958 |
| 18303 | 18303 | 1fd76 | 2959 2959 |
| 21522 | 21522 | 1fd76 | 2903 2903 |
| 21697 | 21697 | 1fd76 | 2900 2900 |
| 22276 | 22276 | 1fd76 | 2902 2902 |
| 23040 | 23040 | 1fd76 | 2901 2901 |
| 28316 | 28316 | 1fd76 | 3182 3182 |
| 28589 | 28589 | 1fd76 | 3273 3273 |
| 28624 | 28624 | 1fd76 | 3276 3276 |
| 28707 | 28707 | 1fd76 | 3274 3274 |
| 28797 | 28797 | 1fd76 | 3183 3183 |
| 28860 | 28860 | 1fd76 | 3184 3184 |
| 28933 | 28933 | 1fd76 | 3272 3272 |
| 28955 | 28955 | 1fd76 | 3270 3270 |
| 29246 | 29246 | 1fd76 | 3185 3185 |
| 29307 | 29307 | 1fd76 | 3264 3264 |
| 29318 | 29318 | 1fd76 | 3275 3275 |
| 29362 | 29362 | 1fd76 | 3268 3268 |
| 30076 | 30076 | 1fd76 | 3269 3269 |
| 36214 | 36214 | 1fd76 | 2969 2969 |
| 36365 | 36365 | 1fd76 | 2968 2968 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)