This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21242 | 21242 | b0c29 | 2939 2939 |
| 21677 | 21677 | b0c29 | 2952 2952 |
| 21925 | 21925 | b0c29 | 2950 2950 |
| 22245 | 22245 | b0c29 | 2954 2954 |
| 22336 | 22336 | b0c29 | 2940 2940 |
| 23009 | 23009 | b0c29 | 2953 2953 |
| 23271 | 23271 | b0c29 | 2941 2941 |
| 23348 | 23348 | b0c29 | 2920 2920 |
| 23626 | 23626 | b0c29 | 2911 2911 |
| 23680 | 23680 | b0c29 | 2917 2917 |
| 23708 | 23708 | b0c29 | 2915 2915 |
| 24024 | 24024 | b0c29 | 2912 2912 |
| 24070 | 24070 | b0c29 | 2916 2916 |
| 24446 | 24446 | b0c29 | 2921 2921 |
| 24560 | 24560 | b0c29 | 2933 2933 |
| 24977 | 24977 | b0c29 | 2914 2914 |
| 25010 | 25010 | b0c29 | 2937 2937 |
| 25200 | 25200 | b0c29 | 2919 2919 |
| 25309 | 25309 | b0c29 | 2936 2936 |
| 25812 | 25812 | b0c29 | 2908 2908 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)