This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21244 | 21244 | 266f1 | 2939 2939 |
| 21680 | 21680 | 266f1 | 2952 2952 |
| 21932 | 21932 | 266f1 | 2950 2950 |
| 22248 | 22248 | 266f1 | 2954 2954 |
| 22338 | 22338 | 266f1 | 2940 2940 |
| 23012 | 23012 | 266f1 | 2953 2953 |
| 23273 | 23273 | 266f1 | 2941 2941 |
| 23350 | 23350 | 266f1 | 2920 2920 |
| 23631 | 23631 | 266f1 | 2911 2911 |
| 23683 | 23683 | 266f1 | 2917 2917 |
| 23711 | 23711 | 266f1 | 2915 2915 |
| 24031 | 24031 | 266f1 | 2912 2912 |
| 24073 | 24073 | 266f1 | 2916 2916 |
| 24448 | 24448 | 266f1 | 2921 2921 |
| 24980 | 24980 | 266f1 | 2914 2914 |
| 25013 | 25013 | 266f1 | 2937 2937 |
| 25202 | 25202 | 266f1 | 2919 2919 |
| 25311 | 25311 | 266f1 | 2936 2936 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)