This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26962 | 26962 | 65f34 | 3327 3327 |
| 26963 | 26963 | 371f0 | 3327 3327 |
| 26964 | 26964 | 5e075 | 3327 3327 |
| 26965 | 26965 | 59d75 | 3327 3327 |
| 26966 | 26966 | e6200 | 3327 3327 |
| 26967 | 26967 | b1201 | 3327 3327 |
| 26968 | 26968 | a50f7 | 3327 3327 |
| 26969 | 26969 | d5ec6 | 3327 3327 |
| 26970 | 26970 | d3559 | 3327 3327 |
| 26971 | 26971 | 649a5 | 3327 3327 |
| 26972 | 26972 | 10d3d | 3327 3327 |
| 26973 | 26973 | b1e1d | 3327 3327 |
| 26974 | 26974 | 03778 | 3327 3327 |
| 26975 | 26975 | a1f8b | 3327 3327 |
| 26976 | 26976 | 37724 | 3327 3327 |
| 26977 | 26977 | 32bde | 3327 3327 |
| 26978 | 26978 | 06ae5 | 3327 3327 |
| 26979 | 26979 | 710d1 | 3327 3327 |
| 26980 | 26980 | 943de | 3327 3327 |
| 26981 | 26981 | 8d650 | 3327 3327 |
| 26982 | 26982 | 7c580 | 3327 3327 |
| 26983 | 26983 | fa448 | 3327 3327 |
| 26984 | 26984 | e1dcf | 3327 3327 |
| 26985 | 26985 | f58f7 | 3327 3327 |
| 26986 | 26986 | 7c76f | 3327 3327 |
| 26987 | 26987 | e737a | 3327 3327 |
| 26988 | 26988 | e7176 | 3327 3327 |
| 26989 | 26989 | c45c4 | 3327 3327 |
| 26990 | 26990 | 2ed38 | 3327 3327 |
| 26991 | 26991 | 60bee | 3327 3327 |
| 26992 | 26992 | 2aa57 | 3327 3327 |
| 26993 | 26993 | 962c9 | 3327 3327 |
| 26994 | 26994 | 762c9 | 3327 3327 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)