This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7934 | 7934 | cc5ed | 2488 2488 |
| 7935 | 7935 | 16102 | 2488 2488 |
| 7936 | 7936 | d6ade | 2488 2488 |
| 7937 | 7937 | 8e7b3 | 2488 2488 |
| 7938 | 7938 | 9d04d | 2488 2488 |
| 7939 | 7939 | 8da48 | 2488 2488 |
| 7940 | 7940 | d4e6c | 2488 2488 |
| 7941 | 7941 | e9db4 | 2488 2488 |
| 7942 | 7942 | f6590 | 2488 2488 |
| 7943 | 7943 | 2a6ea | 2488 2488 |
| 7944 | 7944 | 51b28 | 2488 2488 |
| 7945 | 7945 | 235b1 | 2488 2488 |
| 7946 | 7946 | a0f55 | 2488 2488 |
| 7947 | 7947 | 2cd39 | 2488 2488 |
| 7948 | 7948 | 1073c | 2488 2488 |
| 7949 | 7949 | 1c31d | 2488 2488 |
| 7950 | 7950 | e6200 | 2488 2488 |
| 7951 | 7951 | b1201 | 2488 2488 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)