This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33920 | 33920 | ec3ac | 812 812 |
| 33921 | 33921 | b668a | 812 812 |
| 33922 | 33922 | d9950 | 812 812 |
| 33923 | 33923 | 5e075 | 812 812 |
| 33924 | 33924 | 59d75 | 812 812 |
| 33925 | 33925 | e6200 | 812 812 |
| 33926 | 33926 | b1201 | 812 812 |
| 33927 | 33927 | 5ce50 | 812 812 |
| 33928 | 33928 | 3803a | 812 812 |
| 33929 | 33929 | 7a351 | 812 812 |
| 33930 | 33930 | 0593a | 812 812 |
| 33931 | 33931 | eecd9 | 812 812 |
| 33932 | 33932 | 2d469 | 812 812 |
| 33933 | 33933 | 973aa | 812 812 |
| 33934 | 33934 | 663d7 | 812 812 |
| 33935 | 33935 | e128e | 812 812 |
| 33936 | 33936 | d75c0 | 812 812 |
| 33937 | 33937 | e9f7c | 812 812 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)