This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7858 | 7858 | ec3ac | 1164 1164 |
| 7859 | 7859 | 16102 | 1164 1164 |
| 7860 | 7860 | e17ba | 1164 1164 |
| 7861 | 7861 | e5284 | 1164 1164 |
| 7862 | 7862 | ade9f | 1164 1164 |
| 7863 | 7863 | e9db4 | 1164 1164 |
| 7864 | 7864 | 1f895 | 1164 1164 |
| 7865 | 7865 | a5df2 | 1164 1164 |
| 7866 | 7866 | d4179 | 1164 1164 |
| 7867 | 7867 | 5c628 | 1164 1164 |
| 7868 | 7868 | c3780 | 1164 1164 |
| 7869 | 7869 | aabe0 | 1164 1164 |
| 7870 | 7870 | 3e5f6 | 1164 1164 |
| 7871 | 7871 | d582c | 1164 1164 |
| 7872 | 7872 | 8de7c | 1164 1164 |
| 7873 | 7873 | 87fac | 1164 1164 |
| 7874 | 7874 | 32c58 | 1164 1164 |
| 7875 | 7875 | 1073c | 1164 1164 |
| 7876 | 7876 | 878ce | 1164 1164 |
| 7877 | 7877 | c3b9b | 1164 1164 |
| 7878 | 7878 | 5e075 | 1164 1164 |
| 7879 | 7879 | 59d75 | 1164 1164 |
| 7880 | 7880 | e6200 | 1164 1164 |
| 7881 | 7881 | b1201 | 1164 1164 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)