This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21243 | 21243 | 87529 | 2939 2939 |
| 21678 | 21678 | 87529 | 2952 2952 |
| 21927 | 21927 | 87529 | 2950 2950 |
| 22246 | 22246 | 87529 | 2954 2954 |
| 22337 | 22337 | 87529 | 2940 2940 |
| 23010 | 23010 | 87529 | 2953 2953 |
| 23272 | 23272 | 87529 | 2941 2941 |
| 23349 | 23349 | 87529 | 2920 2920 |
| 23565 | 23565 | 87529 | 2934 2934 |
| 23628 | 23628 | 87529 | 2911 2911 |
| 23681 | 23681 | 87529 | 2917 2917 |
| 23709 | 23709 | 87529 | 2915 2915 |
| 24026 | 24026 | 87529 | 2912 2912 |
| 24071 | 24071 | 87529 | 2916 2916 |
| 24159 | 24159 | 87529 | 2909 2909 |
| 24447 | 24447 | 87529 | 2921 2921 |
| 24561 | 24561 | 87529 | 2933 2933 |
| 24849 | 24849 | 87529 | 2910 2910 |
| 24978 | 24978 | 87529 | 2914 2914 |
| 25011 | 25011 | 87529 | 2937 2937 |
| 25157 | 25157 | 87529 | 2935 2935 |
| 25201 | 25201 | 87529 | 2919 2919 |
| 25310 | 25310 | 87529 | 2936 2936 |
| 25813 | 25813 | 87529 | 2908 2908 |
| 29590 | 29590 | 87529 | 2966 2966 |
| 29693 | 29693 | 87529 | 2967 2967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)