This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16919 | 16919 | 6b1c5 | 3369 3369 |
| 16920 | 16920 | 7b150 | 3369 3369 |
| 16921 | 16921 | 5e075 | 3369 3369 |
| 16922 | 16922 | 59d75 | 3369 3369 |
| 16923 | 16923 | e6200 | 3369 3369 |
| 16924 | 16924 | b1201 | 3369 3369 |
| 16925 | 16925 | 8a7ee | 3369 3369 |
| 16926 | 16926 | 862ed | 3369 3369 |
| 16927 | 16927 | 13ab6 | 3369 3369 |
| 16928 | 16928 | 18a64 | 3369 3369 |
| 16929 | 16929 | 66f82 | 3369 3369 |
| 16930 | 16930 | f788a | 3369 3369 |
| 16931 | 16931 | 7c38f | 3369 3369 |
| 16932 | 16932 | df1f0 | 3369 3369 |
| 16933 | 16933 | a1307 | 3369 3369 |
| 16934 | 16934 | 809af | 3369 3369 |
| 16935 | 16935 | 4225c | 3369 3369 |
| 16936 | 16936 | 93975 | 3369 3369 |
| 16937 | 16937 | 27369 | 3369 3369 |
| 16938 | 16938 | e128e | 3369 3369 |
| 16939 | 16939 | 9c206 | 3369 3369 |
| 16940 | 16940 | 7c580 | 3369 3369 |
| 16941 | 16941 | 724f8 | 3369 3369 |
| 16942 | 16942 | b6f60 | 3369 3369 |
| 16943 | 16943 | 06d39 | 3369 3369 |
| 16944 | 16944 | 2ab82 | 3369 3369 |
| 16945 | 16945 | 8b0bf | 3369 3369 |
| 16946 | 16946 | 01e8a | 3369 3369 |
| 16947 | 16947 | 2aa57 | 3369 3369 |
| 16948 | 16948 | 425d7 | 3369 3369 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)